I was wondering how LIKE clause will behave in the following scenario.
I have a query where I'm using LIKE clause as follows,
Code: Select all
SELECT COL-1, COL-2, COL-3
FROM TABLE1
WHERE COL-1 LIKE 'ABC%'
Now, If I'm checking exactly the same length data against the LIKE clause, will it behave like EQUAL condition check.
Code: Select all
SELECT COL-1, COL-2, COL-3
FROM TABLE1
WHERE COL-1 LIKE 'ABCD'
I've tried this myself as I don;t have much data in our tables, I couldn't see the difference.
Please let me know if the above scenario is not clear.
Thanks in advance.