AxISQS
asked on
transact-sql most efficient way to parse a string in a colum
What is the most efficient way to parse a string to get 2 pieces:
string: AI-POL-12345.889900
piece 1: everything between the 'POL-' and '.' (in this example 12345)
piece 2: everything between the '.' and the end (in this example 889900)
Thanks in advance!
string: AI-POL-12345.889900
piece 1: everything between the 'POL-' and '.' (in this example 12345)
piece 2: everything between the '.' and the end (in this example 889900)
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER