Hi Everyone.
I need to run an extract of some data from our Oracle DB's. One of the
restrictions is that I need to write a SQL script that will parse through a
particular field for a "/"
and if found, I have to remove it and output the data without the slash.
I have minor experience with selectin
Memon, Michele would like to recall the message, "Need help with query
result".
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
Hello Everyone,
I haven't used SQL in a long time and I am having trouble designing the
query to get the result I need. I have 1 select query that looks like this:
SELECT WC.FIRST_NAME & ' ' & WC.LAST_NAME AS NAME, C.COMM_NO AS PHONE
FROM WRK_CNTRCTR AS WC, WRK_COMM_NUMBER AS C
WHERE WC.PERS_ID =