I'm in desperate need of some help with an SQL Update
query...
I have a column that contains serial numbers and a fail
code divided by a dash. I would like to split the columns
into two separate columns but, the problem is they aren't
the same length.
example: 980890121-1, 239451-1, 000509197Z-1, 4333260-1
what would the correct syntax be for my statement?
I know I want to start at one but what is the length going to be? It could be different on all of them?
Update CallLog
set SerialNumber = substring(CLSerialNumber, 1, ?
this is where I'm stuck! Please help!
Please help! Thanks Gabby
query...
I have a column that contains serial numbers and a fail
code divided by a dash. I would like to split the columns
into two separate columns but, the problem is they aren't
the same length.
example: 980890121-1, 239451-1, 000509197Z-1, 4333260-1
what would the correct syntax be for my statement?
I know I want to start at one but what is the length going to be? It could be different on all of them?
Update CallLog
set SerialNumber = substring(CLSerialNumber, 1, ?
this is where I'm stuck! Please help!
Please help! Thanks Gabby