J Mason
Last Activity: Sep 21 '10, 10:01 PM
Joined: Sep 20 '10
Location:
-
I tried it, it ran for an inordinate amount of time and returned the wrong answer. -
How to concatenate 3 fields in a where statement see attach
SELECT concatenate(por t_npa,port_nxx, port_line)as account
FROM DBxx.blah.TLRNC URR
WHERE account = 1234567891
OR
SELECT *
FROM DBxx.blah.TLRNC URR
WHERE concatenate (port_npa,port_ nxx,port_line)= 1234567891
Either way it doesn't work, I'm using QMF v.8
No activity results to display
Leave a comment: