At the very least the WWW consortium does not agree that there is no such thing.

‘ is left single quote

’ is right single quote

--EDIT--

Proof...I typed in the html escape...

I am totally lost now...are you saying that it changed your inner joins to left and right joins?? You have me stumped.

Get rid of the NOT to keep is ARGable.

where RecordId = 3212

...

Maybe combine them into a single select?

where RecordId = 3212

and

(select case when AlphaNumeric2 = '2012' then 0 else 1 end +

case when...

That will work as long you don't care about missing/duplicate data or a host of other nearly impossible bugs to figure out. I would highly recommend you get very familiar...

twahl0630 (1/3/2013)

---

Hello all

need to find a faster way to do this select into I'm using or ststatementso filter on multiple columns

any ideas

select m.RecordId,m.NumberForSearch into #dump

from table1...

Are you using the GUI to build your view? I have not seen the behavior you are talking about. I created a view and when scripting it back out the...

This isn't something you can control from your code. That is how Outlook displays the text. There is a user setting in Outlook disable that feature but it is somewhat...

Good topic for a question. However since I always try to get the answer without running the code I tend to really dislike questions with this level of nested logic....

tony@kenny.net (1/3/2013)

---

I used to use dynamic SQL but it was always so ugly and not particularly friendly when it comes to code maintenance.

I was also concerned about how well it...

For an even better solution stop using dynamic pass through sql and do this with a stored proc. The advantages are numerous. You can avoid sql injection, debugging is a...

Take a look at Gail's post. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

She explains how to deal with this type of thing very cleanly.

roger.plowman (1/3/2013)

---

This issue is yet another example of why SQL is one of the worst-designed languages of all time from a syntactic POV.

Would it have killed the designers to create...

Then you must have some non-display characters in your data. Try outputting select * to text instead of the grid. Do you...

In my position what is a worthy programming language to learn that will continue to be the standard in dev? .NET? How can I practice? In Visual Studio? Another reason...