script with '

[adiarnon]

hi,

i want to write in my script:

if(fieldname= 'abc'd' , 'a' , fieldname) as fieldname

' - its a part of the word....

how can i do that?

tnx

[rustyfishbones]

you could use CHR(39)

[Anonymous]

if(fieldname= =  'abc' & chr(39) & 'd', 'a' , fieldname) as fieldname