Em Andamento

SQL Replace function

Hi there,

I'm looking for a SELECT statment or some sort of a user defined function for MSSQL2K that will allow me to:

pass 2 parameters (delimeted list of keywords, column name) and to get a string returned with the found keyword(s) in column name highlighted (i.e - <b>keyword</b>).

For example:

I will pass:

"hello world" with the string: "good morning, what a wonderful world we're living in", I will get:

"good morning, what a wonderful <b>world</b> we're living in" (make sure you keep the same amount of spaces).

The function should allow to pass 2, 3.. N number of keywords that would be replaced. i.e, passing "we're living in" would give <b>we're</b> <b>living</b> <b>in</b> a wonderful world.

The column I want to make the replace on is a varchar(4000).

Obviouslly, we can make use of the normal REPLACE function with some kind of a loop, right?

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

plain T-SQL that works with MSSQL2K

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: package sql, number function, function number, sort function, replace, php statment, sql run package, sql keyword, sql select, column php loop, php normal distribution, php form sql, sql replace keywords, normal distribution php, string function, package sql distribution, normal distribution, looking sql work, column loop php, sort sql, php loop column example, sql number, replace sql, php loop form, php column loop

Acerca do Empregador:
( 31 comentários ) Israel

ID do Projeto: #2971621

Premiar a:

leejfalin

See private message.

$21.25 USD em 10 dias
(3 Avaliações)
2.3

19 freelancers estão ofertando em média $34 para este trabalho

TakeRealUK

See private message.

$8.5 USD in 10 dias
(551 Comentários)
6.7
cartzlink

See private message.

$12.75 USD in 10 dias
(90 Comentários)
5.6
sissoftware

See private message.

$55.25 USD in 10 dias
(18 Comentários)
4.9
thelimeyvw

See private message.

$21.25 USD in 10 dias
(9 Comentários)
4.2
krymar

See private message.

$25.5 USD in 10 dias
(13 Comentários)
3.7
horizonconsultvw

See private message.

$85 USD in 10 dias
(4 Comentários)
2.3
aweinstein

See private message.

$10.2 USD in 10 dias
(3 Comentários)
2.3
bwsolutionsvw

See private message.

$63.75 USD in 10 dias
(3 Comentários)
1.6
raymondvelasquez

See private message.

$12.75 USD in 10 dias
(1 Comentário)
1.4
tom74vw

See private message.

$17 USD in 10 dias
(0 Comentários)
0.0
vanvuure

See private message.

$8.5 USD in 10 dias
(0 Comentários)
0.0
eduardomari

See private message.

$19.55 USD in 10 dias
(0 Comentários)
0.0
ruskievw

See private message.

$68 USD in 10 dias
(0 Comentários)
0.0
devniall

See private message.

$21.25 USD in 10 dias
(0 Comentários)
0.0
mrlovemonkeyvw

See private message.

$51 USD in 10 dias
(0 Comentários)
0.0
muhammadadilvw

See private message.

$17 USD in 10 dias
(0 Comentários)
0.0
h042

See private message.

$29.75 USD in 10 dias
(0 Comentários)
0.0
theverybestvw

See private message.

$85 USD in 10 dias
(0 Comentários)
0.0
enotech

See private message.

$25.5 USD in 10 dias
(0 Comentários)
0.0