Use the Count Algorithm to Perform Simple Validation on Strings
Sometimes it’s necessary to perform a simple validation on a string to ensure, for example, that a string destined to be converted to a float contains only a single ‘.’.
Sometimes it’s necessary to perform a simple validation on a string to ensure, for example, that a string destined to be converted to a float contains only a single ‘.’.
What if you wanted to use a COM object through TSQL Statement? SQL Server facilitates this task by provding a few system sorted procedures like sp_OACreate, sp_OAMethod, etc. Check out