Thats a great example of what Im talking about For example, an SQL API will only accept SQLStrings. To make an SQLString you can use string.Escape(). Theres no way to take input or a value out of a table, and pass it into an SQL api.

Get data munging with these #sqlserver string functions w/ @Prashantjayaram #sqlstrings #stringfunctions #sqlstringfunctions #datawrangling #datamunging bit.ly/2NbEhGW via @SQLShack

Get data munging with these #sqlserver string functions w/ @Prashantjayaram #sqlstrings #stringfunctions #sqlstringfunctions #datawrangling #datamunging bit.ly/2NbEhGW via @SQLShack

@dlitchfield @jstnkndy smash @ params into SQLstrings? That's just MAD! So 2003. IIRC I asked you about this in sprocs back in 2001 or 2. :)

Check out my newly published SQL script on SQLServerCentral.com: PatReplace8K: sqlservercentral.com/scripts… #sqlhelp #textmining #sqlstrings