I have a data file whose key includes a tilde (~).
WITH @ID = 1~12345 returns a lot of records whose keys don't appear to bear any similarity to the term.
Works as expected if I use double quotes around the term. Similarly using the LIKE operator and [ or ] which return a larger count of records.
I'm curious about what the tilde means.
I have a data file whose key includes a tilde (~).
WITH @ID = 1~12345 returns a lot of records whose keys don't appear to bear any similarity to the term.
Works as expected if I use double quotes around the term. Similarly using the LIKE operator and [ or ] which return a larger count of records.
I'm curious about what the tilde means.
The following is a snippet from the MATCH function documentation in the BASIC manual. The '~' character is being interpreted as part of a pattern match. When it is enclosed in quotes, it will be treated as the literal character.
A tilde (~) placed immediately before pattern specifies a negative match.
There is more details in the manual if interested.
Thanks,
Neil
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
