LIKE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Tom Thomson » LIKE

27 posts, Page 1 of 3

1 2 3 »»»

Rate Topic

Display Mode

Topic Options

Author

Message

L' Eomot Inversé

Posted Wednesday, June 23, 2010 8:42 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 PM
Points: 7,088, Visits: 7,143

Comments posted to this topic are about the item LIKE

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #942196

rVadim

Posted Wednesday, June 23, 2010 10:05 PM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:36 PM
Points: 887, Visits: 2,062

Good question.

For some reason I thought it could be True because of some weird implicit conversion, so I came up with this code to get my correct answer:

DECLARE @a CHAR(2);
DECLARE @b INT;

SET @a = '1 ';
SET @b = 1;

IF @a = @b AND @a LIKE @b AND @b NOT LIKE @a BEGIN
  PRINT 'True';
END ELSE BEGIN 
  PRINT 'False';  
END

...and then realized that Tom was asking about same datatype. Right answer for the wrong reason. Hehe

Post #942213

Toreador

Posted Thursday, June 24, 2010 2:29 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356, Visits: 4,761

A good idea, but a bit too easy to guess! Even though I failed to come up with an example, I got it right as the obvious answer was 'not possible', therefore for there to be any point asking the question, the answer had to be 'possible'!

Post #942294

DugyC

Posted Thursday, June 24, 2010 2:42 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 1,162, Visits: 728

Toreador (6/24/2010)

Likewise

_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"

Post #942299

Pradyothana Shastry

Posted Thursday, June 24, 2010 4:25 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, March 25, 2013 5:30 AM
Points: 1,640, Visits: 423

Now this will work

declare @a varchar(16)
set @a ='a '
declare @b varchar(16)
set @b ='a'

if @a = @b and @a like @b and @b not like @a
print 'zzz'

- Pradyothana

http://www.msqlserver.com

Post #942345

ronmoses

Posted Thursday, June 24, 2010 5:32 AM

SSChasing Mays

Group: General Forum Members
Last Login: Today @ 5:12 AM
Points: 649, Visits: 686

I knew it had to be trailing spaces. It's always trailing spaces... Wink

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown

Post #942369

SanjayAttray

Posted Thursday, June 24, 2010 7:36 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

Even though I got it right and know its possible but when executed in SSMS 2005 it returned error.

Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@a".

SQL DBA.

Post #942440

Sean Lange

Posted Thursday, June 24, 2010 7:40 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:34 PM
Points: 8,592, Visits: 8,233

Toreador (6/24/2010)

This logic is hilarious!!! It reminds me of the discussion in the Princess Bride between Wesley and the "inconceivable" guy about which glass has the poison in it. Tongue

As funny as it was I followed pretty much the same train of thought.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #942444