Hi, I use a database program that has a series of preset queries (with selections for the query); however, there is an optional part of the query that allows T-SQL code to add new columns, etc. in the query output.
I have a column in the database called "Identifier" It is populated with values such as this:
and so forth
The total length of the string isn't consistent and neither are the character lenghts between the "_" underscores.
What i want to make are 3 new columns delimited by the "_" underscores as such
Ident_1 Ident_2 Ident_3
55666 BXY23 BYY23
51432 MBYT22 MBXX23
I was using substring and charindex to accomplish this, but since there are two "_" underscores in this field I wasn't able to return what I wanted.
Any help would be appreciated.