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 |
|
fried_onion_rings
Starting Member
2 Posts |
 Posted - 2003-04-15 : 12:19:01
|
| Hi,I'm hoping someone can help,I need to confirm if the SQL 'LIKE' clause is standard SQL and to which spec this belongs to.Better still, if someone could direct me to a good online resource where such SQL specs are maintained, this would be very handy (I've tried intensive serarching on google and the results are dissapointing).thanks for any helpRobEdited by - merkin on 04/15/2003 12:40:48 |
|
|
macka
Posting Yak Master
162 Posts |
Posted - 2003-04-15 : 12:28:40
|
| I was under the impression that it is. Take a look at :[url]http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt[/url]However, I'm not sure that this is up-to-date.Probably worth a trip to the ANSI and/or ISO sites, although from what I remember they aren't the most intuitive sites to navigate - and - you may have to pay for some of the content !Cheers,macka.Also worth looking at this post:[url]http://www.tek-tips.com/gfaqs.cfm/pid/220/fid/1073[/url]--There are only 10 types of people in the world - Those who understand binary, and those who don't.Edited by - macka on 04/15/2003 12:30:43 |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-04-15 : 12:32:47
|
| http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txtI believe this is a draft of SQL-92 standard ... Yes, the like predicate is standard.EDIT: sniped.Jay White{0}Edited by - Page47 on 04/15/2003 12:33:13 |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-04-15 : 12:48:04
|
| Be careful, though. I didn't read the docs linked, but even though LIKE may be ANSI compliant, SQL Server might not (and I have no idea about this) implement the LIKE operator in exactly the way the standards dictate.- Jeff |
|
|
|
LarsG
Constraint Violating Yak Guru
284 Posts |
Posted - 2003-04-15 : 12:54:18
|
| Using like with [range] and [^range] is not standard SQL. |
|
|
|
fried_onion_rings
Starting Member
2 Posts |
Posted - 2003-04-15 : 12:56:35
|
| Thanks for your help,I'll trawl through the spec and draw some conclusions :) |
|
|
|
|
|
|
|
|
Is LIKE standard SQL?