Defining SQL select statement

[TracyV]

I am trying to create an SQL statement that will be populated by the user. The problem I am experiencing has to do with the quotes needed around the selection. When I define a constant field in the D specs i have to define it as '"', but what i really want is '''. How do I get around this problem???

Thanks much!!

Tracy

 

[iSeriesCodePoet]

Try '''' or try:

     D @Q              C                   Const(X'7D')                         Single Quote

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net

 

[TracyV]

Thank you for your help....works great!

 

[iSeriesCodePoet]

No problem

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net