How to create a function ?

[Keiko]

Hi anyone,

I know this one isn't a VB question, but
I need the solution for my VB project, hope
anyone can help me.

How to create a function in MS-SQL6.5 with a
return value ?

I want to create a function which can replace
char(s) in a string with another char.

example,


select xReplace('Hello','l','x') -- will return Hexxo
select xReplace('Bye','y','o') -- will return Boe


I know the logic in replacing, but I don't know
how to create a function, not a stored procedure.

Is there any built-in function for this ?

Thank you


[This message has been edited by Keiko (edited 12-03-1999).]