In this article you will learn how to get a character, numeric or special character string value in SQL server.
In this user defined function many system predefined functions are used. This function returns table type data because I wrote it as a table valued function. This type of function returns a table type of data. This function has two parameters, one is @value and the other is @condition. The @value parameter holds the string value like "asdf1234#^$&, asdf878*&^7" and the @condition parameter has the condition like "%[a-z0-9]%". We don't need the name of the table, this @tamptable is hidden. We need only the name of the column (filter).Why we need itset @value+=',' we need it because the loop skips the last value after the "," (comma). This loop continues until @length is set to the value zero.
Basic SQL Queries