How to Replace a dynamic string in select statemen

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

How to Replace a dynamic string in select statemen

Author

Topic

jack1
Starting Member

1 Post

Posted - 2003-09-14 : 17:54:31

Hi Freinds,

Can you help me to solve my porblem.

With my Sql Statement i am retrieving morethan 1 records. In this one field values i have to replace with another field value.

ex: Description POS POD

Result :1. The Shipment Starting from [POS] to blaw blaw, ABC, XYZ
2. The Shipment Starting from bla blaw to [POD], ABC, XYZ

here The output should come like :
1 .The Shipment Starting from 'ABC' to blaw blaw
2. The Shipment starting from bla bla to 'XYZ'

how to replace dynamically this [POS],[POD] values for the records in SQL Statement. and the Description field is varchar(1500)

Please help me to solve my problem

Regards

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-09-14 : 18:48:45

Look up the REPLACE function in books on-line.

If you need help, let us know.

- Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources