Yes, that's how I'm reading it and Sean's clause should give that. The OP's definitely won't.

Sean Lange (9/25/2013)

---

frdrckmitchell7 (9/25/2013)

---

Thank you for your response:

I've built the (part of) query like this:

(IM.ItemCode BETWEEN '999999' AND 'CL00000'

OR IM.ItemCode NOT LIKE '001920'

OR IM.ItemCode NOT LIKE '001921'

...

Yes - provided you are using .NET.

You can also do it on VS6 or earlier but it will be a lot harder as you will need to call...

This can happen if something on your system corrupts the memory used by SSMS. It suggest that some application installed on your system has a memory leak or otherwise accesses...

2nd Jan should also be in Scotland

mike.dinnis (9/4/2013)

---

I think you're right. The more I read into this area the more it seems that the actual installation media/licence doesn't matter so long as the safe has enough...

How I understand this is that you are an employee of Company A and should have a contract of employment with them. Company A has sold your services to Company...

ChrisM@Work (7/29/2013)

---

The OP is now selling real estate in Argentina, 3 1/2 years later.

Margarett, if the leftmost part of the Desc...

Replication - shouldn't be a problem - just assign that to the Kids role - they're all glued to their mobiles doing exactly that in any event.

Couldn't a KVM be used to do this?

If the next step is to check why it failed that would be fine.

If it failed because it already exists then the job can continue but if it failed...

I suppose you could set the application up to use a different account and set a windows shortcut to the application to run it as that account. Expect lots of...

Something like this - probably not particularly efficient but it should work.

SET @MatchExpression= ''%[''+@MatchExpression+'']%''

WHILE PATINDEX(@MatchExpression,@String)>0

SET @String=STUFF(@String, PATINDEX(@MatchExpression, @String),1, '''')

Where @MatchExpression is a regular expression to define your permitted characters.

Jan Van der Eecken (6/19/2013)

---

Even last name won't be accurate. My surname is sometimes spelled in three words, sometimes two, or even in one word. And then there may be...

Jan Van der Eecken (6/18/2013)

---

May I humbly ask why you want to do this in the first place? My first name is Jan, which is both Dutch, Afrikaans and Polish...