SQL Query to Extract after 2nd dash in a field
SQL Query to Extract after 2nd dash in a field
(OP)
I am trying to extract the 5-digit number out of a field that is formatted in the following manner:
XXXX-###-#####-#########-#
I need to extract the 5-digit number (highlighted) after the second '-' . I'd like to use SUBSTRING if possible in SQL. Help???
XXXX-###-#####-#########-#
I need to extract the 5-digit number (highlighted) after the second '-' . I'd like to use SUBSTRING if possible in SQL. Help???
RE: SQL Query to Extract after 2nd dash in a field
Matt
"Nature forges everything on the anvil of time"
www.anvil-of-time.com