Problems with Apostrophies in String Variables

[Rob7]

Hi All,
I am executing a sql statement to get two field values based on two other field values. Most of the time this works, but one of my conditional fields can have an apostrophy in the field and I get a run time error. The statement is being executed against an MS SQL. Is there some way to get around this? I don't think I can kep the users from putting an apostrophy in the string field to begin with.

Thanks.

Rob

 

[vb5prgrmr]

try...
[tt]
YourVariable = Replace(YourVariable,"'","''&quot
[/tt]

Good Luck

 

[DerFarm]

you can massage the input by replacing the ' with `. Your users won't know the difference but the machine will.

`=lowercase umlaut (upper left hand corner)