We are trying to pull the number 1 from the below string. To be sure its the number 1 located after the third LIT~(
This value will always be after the third LIT~( string. We were trying to use the charindex but couldn't get it to work.
Thanks we are using sql 2000.