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.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 17:58:23 EDT