CONCAT in UPDATE query won't work

[renepaulin]

Hi,

Can someone tell me why this won't work for me ?

UPDATE Temp
SET Field2 =('LEFT(Field2,'*-')' CONCAT '0' CONCAT 'RIGHT(Field2,' #')')
WHERE Field2 LIKE '*- #';

I'm getting a syntax error on the SET line.

Thanks,

 

[PHV]

What do you want to do ?
Take a look at the InStr function and the & operator.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[renepaulin]

Hi PHV,

The & operator did the job,

Thanks