Exists a TSQLCommand for auto remove of Special Charac. in a SQLQuery? 2

[sa5cha]

Hello,

I have a question again.
Does a TSQLCommand for auto remove of Special Characters in a SQLQuery exists ?

It is pretty boring to programm these routine again and again in a Stored Procedure.

It is because I got the values via ASP from a webform.
I want to do all the checking on the SQL-Server side.

If anyone knows a command please let me know it.
I found nothing.

Thank you Sascha

 

[IonelBurtan]

Check the topic "Executing SQL Statements Using HTTP" in Sql Books Online. It gives you information of how you can use XML to retrieve data from SQL Server.

Form the discution in that article it seems that SQL Server has a built-in tranformation for Special Caracters but does not offer it like a function to the programmer.

Hope this helps,s-) Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...

http://home.domaindlx.com/ionelb

 

[foxdev]

Other than what BurtanI suggested, the only other thing I can think of is using the REPLACE function to strip out the unwanted characters. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[TomSark]

Yes, I use REPLACE to strip out unwanted characters from a string. Simply replace them with spaces or whatever...

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com