|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
October 9th, 2000, 08:40 PM
|
|||
|
|||
|
SELECT EMP.ID WHERE EMP.ID LIKE 'RO*' doesn't work
<i><b>Originally posted by : Armando Corazon (a_corazon@hotmail.com)</b></i><br />Does anybody knows why I can't retrieve any record from a table usin the Like filter in an SQL Statement??<br /><br /> <br /><br /><br />
|
|
#2
May 22nd, 2001, 11:43 AM
|
|||
|
|||
|
<i><b>Originally posted by : </b></i><br /><br /><br /><br />------------<br />Armando Corazon at 10/9/2000 6:40:18 PM<br /><br />Does anybody knows why I can't retrieve any record from a table usin the Like filter in an SQL Statement??<br /><br />it not * use ? <br /><br />SELECT EMP.ID WHERE EMP.ID LIKE 'RO?' doesn't work (reply)<br /><br />if works reply at anilrawat22@hotmail.com
|
|
#3
October 9th, 2003, 10:21 AM
|
|||
|
|||
|
You didn't specify wildcards that's all...
SQL Server: "_" replaces 1 char "%" replaces n chars Access: "?" replaces 1 char "*" replaces n chars SELECT EMP.ID WHERE EMP.ID LIKE 'RO%'
|
|
| Viewing: ASP Free Forums > Database > SQL Development > SELECT EMP.ID WHERE EMP.ID LIKE 'RO*' doesn't work |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
