single space and empty string

Question

single space and empty string

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Michelle168 Old Hand Points: 395 More actions · Answer 1

Hi all,

I did a couple test as steve suggested. it turned out no matter mychar is varchar or char, the '' and ' ' are treated as same. I guess I got my answer.

Thanks a lot!!

Ronald San Juan SSCrazy Points: 2937 More actions · Answer 2

Odd... Hmmm...

Try this.

Select case when 'test' like 'test '

then 'The Same'

else 'Not The Same'

end

Ronald San Juan | SQL DBA
ID 710124 ~ Code "Northwind"

Ronald San Juan SSCrazy Points: 2937 More actions · Answer 3

"

I went in just now to look at some tables and I started getting all sorts of error messages...including one where I couldn't even look at the design of a table via EM....it's a good thing I went into the database when I did for if I had done so tomorrow or later, this post would have been faaaar from my mind and I'd have been floundering for some considerable time...

"

Hahaha! Nice one. 6.0 is not compatible with 2k.

Ronald San Juan | SQL DBA
ID 710124 ~ Code "Northwind"