Monday, June 30, 2008

Like Query In SQL

Which of the query executes Perfectly
1) select * from emp where name like'[b-d]%'
2) select * from emp where name ='[b-d]%'

Option 1 Returns the records starting with b,c,d Where as option 2 will not return error, it return empty row

No comments: