Filter on text containing double quote

[heppme]

I have to filter for text where it contains the double quote character in a query. I have found that the ASCII value is 34, but have been unable to apply it correctly within Access.

 

[dhookom]

What is your current SQL view? How are you implementing the "where"?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[heppme]

Here's the where clause:
WHERE (((PROJ.PROJ_NAME) Like "*[ampersand#34;]*") AND ((PROJ.LVL_NO)=4) AND ((PROJ.ACTIVE_FL)="Y") AND ((PROJ.ALLOW_CHARGES_FL)="Y"));

The ampersand is the character, not the word.

 

[heppme]

I've found an inelegant answer to my own question. I stopped checking for the double quote character within the text name and looked for found values off of a function:
InStr(1,[DELTEK_PROJ]![PROJ_NAME],Chr(34)))>0

 

[dhookom]

Try
...WHERE (((PROJ.PROJ_NAME) Like "*""*")...

or
...WHERE (((PROJ.PROJ_NAME) Like "*" & Chr(34) & "*")...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[heppme]

Thanks, the second one worked like a charm!

 

[PHV]

And what about this ?
... WHERE PROJ.PROJ_NAME Like '*"*' ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886