Thanks for the query. Your query is returning this:

1 12345 566767 2020-12-23 thisisaTest test1 test6

1 12345 566767 2020-12-23 thisisaTest test1 test4

1 12345 566767 2020-12-23 thisisaTest test2 test6

I...

I posted the create table and insert script above. I will use your split function

Thank you.

I tried doing this:

select * from testTable

order by

case TestName

when 'Prod' then 1

when...

I used isNumeric and than I could sort the column.

My update statement is working if I am passing NULL instead of empty strings.

I am not looking for splitter function. I am also looking for update statement that will update two other tables table 2 and Table 3 based on the ID provided...

Thank you for taking time to write a test stored procedure. There was something wrong with the stored procedure that was causing the error. Now it is resolved.

I really...

I did that. Now I am getting an error saying:

The conversion of a datetime datatype to a smalldatetime resulted in a out of range value.

The testDate column in the table...

Thank you. Never thought of using replace.

Is there any way, I can just filter out on alphanumeric values and leave the special characters. I tried this, but not working

SELECT * FROM TestTable

WHERE parameter_no LIKE '%[^a-zA-Z0-9]%'

there are lot of values inserting in that table, but this special character will be always at the end if present.

Is there any way, I can see those messages in sql server.