Search for [SPACE] Char and replacing it.

[CharlieMike73]

Hi,

I have to search through a list of user login names and then replace any [space] characters with a . [period].

I know that an ASP webpage is not the best place for it, but these are oracle tables and I do not know how to do recursive statements in PL/SQL+, so did it in VBScript (ASP) instead.

Can someone please tell me how to find the [space] and then replace it with the . [period] in VBScript?

Also, any SQL (Update) code would help too.

Thank you,

 

[cbokowski]

use Replace
heres a link for documentation.

http://msdn.microsoft.com/downloads...s/027/001/728/msdncompositedoc.xml&frame=true