Can one search for a quote character inside text fields

[David Thompson]

Yes, you can. Reading between the lines, so to speak, I suspect your question is really, "can you use the Find/Select... dialog to search for a quote character inside text fields?" That is where it can be a bit tricky, because Panorama automatically wraps quotes around whatever text you type into that dialog, and using quotes to quote text that contains quotes can lead to a syntax error if you don't do it right. The trick is to replace each quote within the text with 2 quotes. So if you have been searching for

SomeField CONTAINS "

then change it to

SomeField CONTAINS ""

or if you are searching for

SomeField CONTAINS Some text with "quotes"

then change it to

SomeField CONTAINS Some text with ""quotes""

If my guess is wrong, and this is actually a statement in a procedure, then you just need to use a different quoting character to quote the text. Something like

Select SomeField contains {"}

or

Select SomeField contains {Some text with "quotes"}

Dave

---- Original message ----
>Date: Sun, 23 Mar 2008 16:30:25 -0500
>From: Jim Henry <max4mac at mac.com>  
>Subject: Can one search for a quote character inside text fields  
>To: "Panorama Questions  Answers (Discussion)" <qna at provue.com>
>
>