[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
Re: [OT] SQL Select statement
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Doogie Brodie wrote:
>select field1, field2 from table where field1 like "%string%"
If you're using MSSQL you need to use ' rather than " for the string
as
someone else posted. :-)
That would probably be because the SQL 92 & 99 [and more than likely
2003] standard requires ' and not ". Slacker DBMS may accept "
but that
actually performs a different role.
Sybex produce an excellent SQL Instant Reference, if you're SQL and not
yet reach deity status, buy it!
- --
Calum Morrell
www.drochaid.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFAvIS5FUM1VQBgP5ARArBxAKCKUtRyjuDdhJZhj17Dcn5Sp6kSDwCeIP/0
AMG7fhN8xXcZ4DjldP7DWDY=
=k2I+
-----END PGP SIGNATURE-----
UKHA_D Main Index |
UKHA_D Thread Index |
UKHA_D Home |
Archives Home
|