Apostrophe in Load Script

[msawyercke]

Hello,

I have the following Load statement:

Pick(Match("Bus. Unit", '010', '050'), 'Toms ', 'Sallys') as "Bus. Unit"

I would like to insert an apostrophe in the statement so that the Business Unit in the Sheet reads "Tom's" and "Sally's", but I get an error message and the load script fails.  I've read some other similar posts, but can't seem to find the correct solution.

Thanks to anyone who could help!

Mike

[dplr-rn · Accepted solution]

you will have to use ascii value for the '
change your code to
'Tom'&chr(39)&'s'

[msawyercke]

Thank you! Correct solution!

[julian]

Good stuff! I've looked all over for this.