RichardKline
asked on
Why does T-SQL SELECT WHERE (DATA LIKE '_2_%') retrieve DATA = '_244_1' ?
The T-SQL statement
SELECT [DATA]
FROM DATABASE
WHERE (DATA LIKE '_2_%')
Retrieves values like _244_1 , _26_1 and _268_1.
Shouldn't it only pick up values like _2_1 and _2_abc ?
Thank you,
SELECT [DATA]
FROM DATABASE
WHERE (DATA LIKE '_2_%')
Retrieves values like _244_1 , _26_1 and _268_1.
Shouldn't it only pick up values like _2_1 and _2_abc ?
Thank you,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Gosh, do I feel silly.
Thanks!
Thanks!
WHERE (DATA LIKE '[_]2[_]%')