directxBOB
asked on
Extracting an ID from a built up string?
I am building up a string a storing them in the database:
eg:
72-8442
I was wondering how I would go about extracting '8442' from this string in SQL because I would like to do:
select serialnumber from assets where id = '8442'
Any ideas?
The Format is always:
ID1-ID2
72-8442
Cheers
eg:
72-8442
I was wondering how I would go about extracting '8442' from this string in SQL because I would like to do:
select serialnumber from assets where id = '8442'
Any ideas?
The Format is always:
ID1-ID2
72-8442
Cheers
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.