The following example illustrates the use of ESCAPE:
To look for the pattern ‘95%’ in a string such as ‘Result is 95% effective’, if Result is the field to be checked, use:
WHERE Result LIKE '%95Z%%' ESCAPE 'Z'
This clause finds the value ‘95%’.
The following example illustrates the use of ESCAPE:
To look for the pattern ‘95%’ in a string such as ‘Result is 95% effective’, if Result is the field to be checked, use:
WHERE Result LIKE '%95Z%%' ESCAPE 'Z'
This clause finds the value ‘95%’.