It was in Sybase SQL Server before their flirtation with Microsoft.

Thank you very much. That seems to do the trick.
Now that I have the hint where to look I'll read the right documentation!

Thank you for your help on this. 
Collation is Latin1_General_CI_AS

FROM_CHAR TO_CHAR
ù ¨

Brilliant. Thank you Sue & Naomi.

I have a table that numbers working days and assigns the number of the next working day to any non-working day, so durations can still be calculated for events involving...

I'm a bit surpised at the behaviour when a number appears in the brackets. Wasn't it once the case that a number would have been interpreted as colid?

It's still not clear whether or not you want to reject "made vile" as unacceptable input for containing a bad word.

If it's acceptable input, then the recommendations about stripping out...

Thank you Gianluca.

I'd spent so much time looking at SQLCMD that I hadn't checked the concatenate_null... setting in Management Studio (and. to be honest, I was convinced the function...

This sounds like something we do .

We have a file that tells a browser-based application the name of the database it should use. New versions of the database (built behind...

This is enought to generate the error:

select patindex(obj,obj) from #temp3

if obj is a varchar(max) column over 42 kb long.

1. If you'd just wanted the amount without the accompanying date you could have had a simple select:

select ProductID,

count(*) partcount,

...

In Sybase T-SQL (where I spend most of my time) UPDATED simply means that the column has been specified in an UPDATE command. It does not mean that the contents...

Beware the difference between dateadd and datediff. If you use dateadd(dd,-7,getdate()) you'll get records inserted since this time last week. Unless you run it at EXACTLY the same time every...