I need a query that returns records that contain 'special' characters e.g. <> *# etc.
I've sorted most of them but I'm stuck on how to search for single & double quote marks, i.e. ' & "
In addition to that, i'm searching for < & >, but i want to exclude strings that look like <xyz> for example.
Any pointers please?
If it helps, this is what I'm using so far..
Like "*[<]*" Or Like "*[>]*" Or Like "*[#]*" Or Like "*[%]*" Or Like "*[;]*" Or Like "*[:]*" Or Like "*/*" Or Like "*[?]*" Or Like "*[.]*" Or Like "*[@]*" Or Like "*$*" Or Like "*{*" Or Like "*}*" Or Like "*|*" Or Like "*^*" Or Like "*[[]*" Or Like "*[]]*" Or Like "*[=]*" Or Like "*[&]*" Or Like "*[+]*" Or Like "*]*"