Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi:
I was trying to use Match () function to restrict loading. I was trying to compare human names in the Match() function.
But I found out that one of the names contain a quotation mark such as O'Donnell. And that would considered as an error when executing the script.
Is there a way to solve this issue?
Thank you very much.
PC
hi
only for filtering propose ,you can create another field where you'll replace the ' sign with other sign
may be *
and after you do the filter you can drop the new field
the replace function should look like
replace(FieldName,chr(39),'*') as FileldNameForFilter
hi
only for filtering propose ,you can create another field where you'll replace the ' sign with other sign
may be *
and after you do the filter you can drop the new field
the replace function should look like
replace(FieldName,chr(39),'*') as FileldNameForFilter
Thank you Liron:
This is a good idea.
PC
just a little suggestion
use other symbol than * because this is used for wild card search , may be #