Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
divyaram
Posting Yak Master
180 Posts |
 Posted - 2012-03-09 : 07:22:06
|
| Hi all,I am struck with one problem. I want to fetch data from a particular table having value like '[recovery','[List] etc. I am not able fetch it in SQL Server 2008This is the query which i have done. select * from dbo.Table_Test where Table_column like '%[%'Regards,Divya |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-03-09 : 07:31:27
|
| [code]select * from dbo.Table_Test where Table_column like '%![%' ESCAPE '!'[/code]Look for the section "Pattern Matching with the ESCAPE Clause" on this page for details: http://msdn.microsoft.com/en-us/library/ms179859.aspx |
 |
|
|
divyaram
Posting Yak Master
180 Posts |
Posted - 2012-03-09 : 07:42:20
|
quote:
Originally posted by sunitabeck
select * from dbo.Table_Test where Table_column like '%
LIKE '[%' is not working