Special Character

[burns642]

Crystal 7
DB2

I am running a query file. In the query there is a where clause: where name = '{?name_parameter}'. The problem that I am running into is that name_parameter can equal a value such as O'brien. I am getting an error that crystal(Db2) is reading the value as 'O'.

thanks,
James

 

[burns642]

Never Mind, I figured it out. I edited the parameter value to O''brien.

thanks