-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Can you escape the paretheses? \(6\)
It might also help to know which database you're using. Perhaps they would
have some kind of documentation about this?
Russell
On Monday 21 June 2004 08:34, Russ Wright wrote:
> Hello All
>
> I have an odd problem. I am doing some work for a client and I need to
> SELECT some rows from a SQL table named PRODUCT based on a PARTNUMBER
> field. The kicker is that the part number field is a character field
> and has parenthesis in it like so:
>
> PARTNUMBER DESCRIPTION
> ---------- -----------
> 12345(6) widget 1
> 12345(7) widget 2
>
> SO my SQL looks like this:
> SELECT * FROM PRODUCT WHERE PARTNUMBER = '12345(6)'
>
> That does not work as () are reserved characters. Any ideas?
>
> Regards
> Russ
>
>
>
> -----------------------------------------------------------------------
> This list is provided as an unmoderated internet service by Networked
> Knowledge Systems (NKS). Views and opinions expressed in messages
> posted are those of the author and do not necessarily reflect the
> official policy or position of NKS or any of its employees.
- --
Linux -- the OS for the Renaissance Man
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFA1uMfAqKGrvVshJQRAswNAKDWlDlvls61Rh9pGDFEBwzk+EhLIwCdHK1X
lsxMNAM7mRLXQELwMRVkzYk=
=J40f
-----END PGP SIGNATURE-----
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 17:58:36 EDT