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

string comparison Expand / Collapse
Author
Message
Posted Monday, February 09, 2009 4:03 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, February 11, 2011 7:01 AM
Points: 91, Visits: 198
Is there a function to compare tow strings.

where a string can a composed of many words with length exceeding 255 characters.

Post #652671
Posted Monday, February 09, 2009 4:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 09, 2009 12:50 AM
Points: 140, Visits: 42
What kind of comparisons do you want to do?
Post #652682
Posted Monday, February 09, 2009 4:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 26, 2012 3:25 AM
Points: 1,389, Visits: 596
nabajyoti.b (2/9/2009)
Is there a function to compare tow strings.

where a string can a composed of many words with length exceeding 255 characters.



in SQL 2005, one string function exists is "DIFFERENCE", for more info see SQL BOL.

:)



Post #652685
Posted Monday, February 09, 2009 2:24 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 22, 2013 11:49 AM
Points: 945, Visits: 998
I think you want an operator.

Dial tone...
Me: Operator? I want to compare two strings please.
Operator: =!=<>

Wow, operators these days are so rude!
Post #653236
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse