query for a string that may or may not have a suffix
I wrote a script that checks a column for a name/number combo, when found it creates the next entry by incrementing the number. It works fine and I have my example below.
Split a string in SQL Server using regex and use the resulted array to populate into Two Different columns
I have a values like this in one of the Column(PIDS) of my SQL Server table. I would like to SPLIT this column into two separate columns based on the ID value Please. Any value after GID: should go to GID column and any value after PACKAGEID: should go to PACKAGEID column. Could you please help me on this.