Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you could use CHR(39)
if(fieldname= = 'abc' & chr(39) & 'd', 'a' , fieldname) as fieldname