Microsoft SQL Sample Code

Search For a Character Field - Like Wildcard Search

This sql script is very useful for finding/searching specific data in a field. You may have a situation where you need to use a wildcard to find data. For example, you may want to search a character field to find all records that start with a certain character or characters, end with a certain character or characters or contain a certain character or characters. The scripts below will show you how to accomplish this.

--Ends With -- This script will return all records that end with a "B" Select YourField From YourTable Where YourField Like '%B' --Starts With -- This script will return all records that start with a "B" Select YourField From YourTable Where YourField Like 'B%' --Contains -- This script will return all records that contain a "B" Select YourField From YourTable Where YourField Like '%B%'

If you need any help implementing this script or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.