Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a special character in a query
Message
From
03/05/2011 18:10:57
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Using a special character in a query
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01509279
Message ID:
01509301
Views:
31
>It's a pattern for any 1 character. See LIKE pattern in BOL.

Thanks, that explains it in very good details.

So, basically, the usage of _ is not optimized. But, we have an updated version of our data and we could use an integer which is indexed to achieve the same search criteria.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform