Hi All,

Thanks for replies.

Since the Asc/Char functions were not returning the correct character for this, I tried something different.

I have managed to resolve this by writing the character to a settings table in my Database using a once off piece of script.

Each time the App loads, I am reading this value into a string variable and this works for the comparison and replace.

It would have been nice to trap the Char value but this solution works nicely.

Michael

OK, 

Here is another test I have run...unsuccessful!

1. If I enter a string which I purposely know has the 'curly quote' as the last character, I use RIGHT(string,1) to get the curly quote character.
2. I use AscA or Asc to get the ASCII value of the character - this returns 146
3. When I try to output this as a character (Char(146) or CharA(146)) it shows no character, also using it in the replaceall() function does not work.

Obviously using step 1. above to allocate the character to a string variable and comparing that or using that in the replaceall() works.  This is no good as I have prior knowledge of the string for testing in the above example and I need the character value to be able to store and use for comparative purposes.

Hope someone can help.

Thanks

another way of doing it would be by excluding the single quote character and replacing the search for 'any' character, using '_' (which would represent any character in a Like in Oracle for example, or '?' in Access, not sure about other databases).

ls_value = ln_stringclass.replaceall(ls_value,"'","''")
ls_value = ln_stringclass.replaceall(ls_value,"ʼ","_")
ls_value = ln_stringclass.replaceall(ls_value,"ʽ","_")
ls_filter_horse_name = " AND HorseName LIKE '%" + ls_value + "%'"

I'd say you can do that the same way you're replacing the single quote with a double quote:

instead of

"ls_value = ln_stringclass.replaceall(ls_value,"'","''")"

do

"ls_value = ln_stringclass.replaceall(ls_value,"'","''")"

AND followed by (for IOS):

ls_value = ln_stringclass.replaceall(ls_value,"’","''")

(hard to perceive, but in red is the normal single quote and in green the curly single quote.

not sure if that's exactly the same curly quote - in the second parameter - which you're getting in IOS ...)