The select a+b worked but not with a +c.

I am trying to create a unique key for some history records, that have a many to one relationship with some account...

Thanks !

Aha!

Works great.

Many Thanks 😀

DECLARE @myvar nvarchar(240)

SET @myvar = 'BLING'

UPDATE PRO

SET Prokw1 = CASE

...

Theoretical question - Since this packaged software uses keyword fields that are populated from a user defined index and synonym table.

How does a Monster.com or Careerbuilder.com do this ?

Do they...

Thanks again for your help!

Thanks !

Thanks, i missed the link, duh!

Not sure how to do nested CASE.

I am trying to do the following.

If the prokw1 is full, goto prokw2.

If the prokw2 is full, goto prokw3.

Why...

UPDATE PRO

IF Len(Prokw1 + ', HL7') <=240 THEN

SET Prokw1= Prokw1 + ', HL7'

ELSEIF Len(Prokw2 + ', HL7') <=240 THEN

SET Prokw2= Prokw2 + ', HL7'

ELSE...

I am at the mercy of packaged software!

I dont have access to the source code, so i am trying to work around this situation 🙁

In the new version of the...

UPDATE pro

set prokw3=', test5erwin'

FROM pro

inner join res on pro.proln=res.resln and

...

The application was written in VB and works with Access, but if you want your DB to store a lot of records, they recommend upsizing to SQL.

I am current running...

I will give that a go! Thanks.

I have another question.

In the table below you can see prokw1 and prokw2 defined with a size of 240 characters.

With all the new features...

UPDATE pro

set prokw2=prokw2+', ONEW'

FROM pro

inner join res on pro.proln=res.resln and

...

Worked like a charm!

Many Thanks 🙂