Simple quote in a field

[#1]

Hi

I have a field which have a quote as :

-  String's

-  J'aime 

How can I handle this in expression like  sum(   If ( FIELD = ' my string value' ,   NumField))  

Any idea

JJ

[shree909]

i am not sure

try this

sum(   If ( FIELD = '[ my string value]' ,   NumField)) 

[#3]

Thanks but it doesnt' work !

[adamwilson · Accepted solution]

try this:

sum(   If ( FIELD = 'J' & chr(39) & 'aime' ,   NumField)) 

instead of   " J'aime "

The Chr(39) substitutes the ' character.

[nagaiank]

Try

sum(   If ( FIELD = 'String' & Chr(39) &'s' ,   NumField))

[#6]

Thanks guys it works like a charm !

JJ