Link to home
Create AccountLog in
Avatar of AxISQS
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!
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of AxISQS
AxISQS

ASKER

thank you!