ListQualify problem: getting two single quotes

[Pahan]

This is driving me nuts already.

For some reason when I use the ListQualify function to insert a single-quote qualifier into the list with comma delimiters I get the items of the list wrapped into TWO single-quote qualifiers on each side.

Example:
FORM.LIST=one,two,three

ListQualify(#Form.LIST#,"'",",","CHAR&quot

I use Oracle database and I get in my query something like:

Select * From x where x.y IN (''one'',''two'',''three'')

Does anyone know what the heck am I doing wrong?

 

[Pahan]

I appologize for this post. There is an answer to this problem in previous posts (use of PreserveSingleQuotes function)

Thanks.