Re: Oracle NULL vs '' revisited

At last, given the attitude you have to get this one corrected I guess the dozens of other errors won't get fixed, here are another two random ones...

One character set to another no equivalent

    ORacle uses CONVERT
    SQL Server uses COLLATE -> <character data> COLLATE <new collation>

Unicode string to a string no equivalent DECOMPOSE

    We use CAST( <unicode> AS <ascii> ) eg. CAST( N'asadasasd' AS varchar(50) )

Infact many of your 'Conversion Functions' are tackled with CAST.

Anyway, you grow tiresome; I'll just work through the corrections myself and post it up when I've finished.

Where on earth did you learn SQL Server from? A packet of corn flakes?

-- 
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson


[Ramblings from the field from a SQL consultant]

http://sqlserverfaq.com


[UK SQL User Community]