Interesting remarks form vv-kirov, though l'eomot's querie is not all incorrect.

The point is that the function char() will give an output based on the character set of the code page...

Right! it's collate latin1_general_ci_as - Case INsensitive... (sorry for posting previous post too soon! )

Strange,

when i run the query that's in my previous post (with the "order by char(i) collate latin1_general_ci_as") i

have the order .... g G H h ...

Sometimes...

I don't think the collation specification is needed after the single character constants ('0' or 'Z') in the "between"-expression, but it is after the expression 'CHAR(i)' - at least,...

Thank you Dan. I've noticed the phrase "with limited succes", 😉 so i'll "proceed with caution"

Thank you Jeffrey! I will check out the provider for sqlServer 2008 as soon as I can.

Lucas

Ok thank you Gsquared, at least now i know it's not possible directly in tsql !

Lucas

thank you for the reply, but:

No this only gives the local instances of the machine i'm connected to (at least that's what i get when i tried it), i want...

Wasn't aware of this behaviour of isnull !

DWIGHT RUTLEDGE (8/13/2009)

---

I had to also do the replacement for spaces. However, I have a weird issue. I copied it into one database and it works great. However, I put...

Okay, now I saw the light 🙂 THX - (found more explanation on http://www.kodyaz.com/articles/sql-set-datefirst-scope-permanent-for-sql-server-database.aspx)

* first day in week depends on language of the session

* language of...

Thank you for sharing this, dates are kind of "fun" (or a pain). Now the script only lacks a parameter to set the first day in the week to Monday...

@SVonTilbon: works fine in sqlserver 2008 express

Hello,

you gave the example of legacy systems not being well documented.

Sometimes it can be the other way arround unfortunately. A change of management, a change of IT-companies, and a...