Eugene Elutin (5/1/2012)

---

I prefer to use "!=" over "<>". Is any reference material where...

This could come in very useful. I'd like to deduct all the French people from the city I live in.

:w00t:...

Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).

As the IsSubdirectory column is a Bit column,...

tt-615680 (5/1/2012)

---

Dear All,

Would anyone be able to let me know how to resolve the following error message please?

Msg 911, Level 16, State 1, Line 1

Database 'databasename' does not exist....

Add

WHERE IsDirectory <> Cast(1 as bit)

to the end of your query.

Actually, it should be very easy. Just have...

A Rampaging Deduper - who said IT can't be exciting?

Indeed & a fair guess. But her post immediately after your suggestion seemed to indicate that things were still...

Tara-1044200 (4/29/2012)

---

actaully there isnt any table in real, i am just trying to use len(column)-12 which seems to be not working but it works for len(column)-8 so i was thinking...

kirkm 55368 (4/29/2012)

---

Thanks for the response, Phil.

I see now using the actual field and table names would have been better.

I'm getting :-

Syntax error (missing operator) in query expression "tblBritburn' Table'.

And...

.Netter (4/29/2012)

---

Hi All,

I have an online exam which inserts the user answers in to a table then works out how many correct answers they have got which is working fine,...

kirkm 55368 (4/29/2012)

---

Hi,

I want to build a query on Multiple Tables... there's 3 tables in total. If they all had a 'Field1'

how could I output all fields (in all 3...

I haven't tried to understand your SELECT query and, as you did not expand on what you meant by "not working", I had to guess that there was a syntax...

Mikalina (4/29/2012)

---

Hello,

this is rather urgent..

I have a population of people who got less than 3 coupons, and i need to insert one specific coupon to that population (the one that...

Bill Nicolich (4/27/2012)

---

Before I go and build the schema, I'd like to compare notes with whomever has either seen this done before or has done this before.

I'm looking to create...