Remove a character from a string

Hi All,

Please guide me how to completely remove a particular character from a string in Sql Server 2000 and display remaining characters of the string.

Thanks in advance.

Regards
Prasanthideclare @.mytxt varchar(50)
set @.mytxt = 'abc123def'

--remove the 2 from the string
set @.mytxt = replace(@.mytxt, '2', '')
select @.mytxt|||Run this simple Query
this will Replace all s from the name field with blank

select replace(name,'s','') from sysobjects

RemoteDataAccess

Dear Friends,

To use RDA, do I still have to use Replication, Publishing? if yes which publication need to be used? is it Transaction

If you can guide me as to how I can imliment RDA, would be a great help.

Check the topic: Remote Data Access (RDA)

at http://msdn2.microsoft.com/en-us/library/aa257442(SQL.80).aspx

It also has examples in the Push/Pull etc methods.

|||

Thankx,

But what I need to know is if i need to use replication publishing of the SQL server db?

Is there any way that I can access the SQL server DB directly?

Regards