Hi
Im using a calc to select values using a where statement to compare text values. This is working correctly other than when the text values contain characters (like & and '). Ive tried a few attempts to remove these characters from the statment however I can not solve the problem correctly.
Could someone kindly offer some advice?
Kind Regards
Im using a calc to select values using a where statement to compare text values. This is working correctly other than when the text values contain characters (like & and '). Ive tried a few attempts to remove these characters from the statment however I can not solve the problem correctly.
Could someone kindly offer some advice?
Kind Regards