What is the wildcard character in SQL?
This is a discussion on What is the wildcard character in SQL? within the Database Support forums, part of the Web Development category; What is the wildcard character in SQL? Let’s say you want to query database with LIKE for all employees ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
04-09-2008, 07:38 AM
| |||
| |||
 What is the wildcard character in SQL? What is the wildcard character in SQL? Let’s say you want to query database with LIKE for all employees whose name starts with La?
__________________ S.VinothkumaR Behind me is infinite power, Before me is Endless Possibility, Around me is Boundless Opportunity, Why should I fear!     |
|
#2
04-09-2008, 08:28 PM
| |||
| |||
 Re: What is the wildcard character in SQL? hi vinoth, I couldnt able to understand, can u explain briefly about wild card character in sql. Just now i heard about wildcard. If u have any sample query means, share with me.
__________________ Krishnakumar.S Beware of Everything -that is un true; stick to the Truth shall succeed slowly but steadily |
|
#3
04-09-2008, 08:44 PM
| |||
| |||
 Re: What is the wildcard character in SQL? Hi, The following example returns all the names of people in the Emp table of Test that start with La. USE Test; GO SELECT Name FROM Emp WHERE Name LIKE 'La%'; GO Thanks Kiruthika |
|
#4
04-10-2008, 10:50 PM
| |||
| |||
 Re: What is the wildcard character in SQL? Hey all, The wildcard character is %, the proper query with LIKE would involve ‘La%’. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| openSTA and end of file character | cindrella | Software Testing | 0 | 02-29-2008 10:12 AM |
| How to get ASCII Value of a first character in a string in php? | $enthil | PHP Programming | 1 | 01-06-2008 10:48 PM |
| Character Embedding | geoblow | Flash Actionscript Programming | 0 | 09-18-2007 12:11 AM |
| NULL character within a string | vigneshgets | C# Programming | 1 | 08-01-2007 04:07 AM |
| Escape Character in MySql | raj | Database Support | 6 | 07-13-2007 04:27 AM |
All times are GMT -7. The time now is 08:13 PM.