Need Help in REPLACE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Need Help in REPLACE

Need Help in REPLACE

Rate Topic

Display Mode

Topic Options

Author

Message

antonyp 46888

Posted Friday, October 01, 2010 4:48 AM

Valued Member

Group: General Forum Members
Last Login: Monday, December 06, 2010 10:01 PM
Points: 62, Visits: 40

Hello,

I have the correct data LIKE - "G" Boys Garden and Christmas Center
IF any anybody searching this name with - ""G" Boys Garden and Christmas Center" ,first and last with " symbol,
how can i get the correct data.

I have tried with Replace('"G" Boys Garden and Christmas Center','"',''), but am not getting the correct data.

Could you please help me on this.

Thanks,
ARP

Post #996527

Stewart "Arturius" Campbell

Posted Friday, October 01, 2010 8:33 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 3,125, Visits: 4,311

What does this data look like in the database you are interrogating?

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #996691

« Prev Topic | Next Topic »

Permissions