Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need Help in REPLACE Expand / Collapse
Author
Message
Posted Friday, October 1, 2010 4:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 6, 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
Posted Friday, October 1, 2010 8:33 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:08 AM
Points: 4,160, Visits: 5,557
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 »

Add to briefcase

Permissions Expand / Collapse