manipulate string using non-sql function

[ItHurtsWhenIThink]

Is it possible to manipulate data using a non-sql function.

Need to encrypt data to my recordset. Have to do it through sql statement. The encryption function is my own.

I was hoping to do something like:

Select MyEnctrypt(id) AS Eid FROM .....

 

[djj55]

Are you talking about is a user defined function or for 2005 and 2008 you can have a CLR (Common Language Runtime).

Personally I can help with the udf but have not used CLR except in practicing.

Good Luck

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!