It's really funny how DBA's and Developers always at each others throats about who is right and who is wrong. Quite sad instead of both professionals just sucking up their...

SELECT dbo.LongitudeFix('23°10''354"')

ALTER FUNCTION LongitudeFix ( @input VARCHAR(80) )

RETURNS FLOAT

AS

BEGIN

IF @input IS NULL

...

My SQL skills are limited and I probably don't know any better but not being able to make use of TRY CATCH in a UDF is simply retarded. IMO anyway.......

Management & Infrastructure investment, sometimes these seem like worlds apart and no matter how much evidence you bring to the table of impending doom. The lack of either understanding or...

i'm not a DBA by trade, but the multi identifier column issue seems more like an attempt to "catch you out" than to make one feel good about one's acquired...

In a perfect world yes, sadly in reality there are many more factors out of your control.

Tis why I quit my job and went Freelance, money not as steady but at least my sanity is.