Author: isjf | Posted on: 4/11/2010 11:39:12 PM | Views : 286


table class
NO    SUBJECT
1     [MIS]
2     [MATH]
3     [CALCULOUS]


when I run this sql script

select * from class
where subject like '%[MIS]%'

the result is
NO    SUBJECT
1     [MIS]
2     [MATH]
3     [CALCULOUS]


why result doesn't not like what I expected?
I think the result should be

NO    SUBJECT
1     [MIS]


does the reason is square brackets ?

thanks alot
...

Go to the complete details ...