I've never seen such a thing.  I have to admit, though, I've never thought to look for such a thing simply because I'd never have thought such a thing was...

You have come across one of the primary reasons why I hate certification courses, exams, and the related books/articles.  They're a possibly decent starting point but, oh my...

IMHO, it is...

There is no way to automatically distinguish differences between dd/mm/yyyy and mm/dd/yyyy for values of mm and dd that are less than 13 and so there is no way to...

Yes... post a couple of links that point to your specific posts on the job posting sites and let us have a look.

I can also tell you that, based on...

Jeff, tell us how you REALLY feel!  You are hilarious.  With that, I have get off here and go share a glass of wine with my sweetheart of 40...

Well, here is an interesting sidelight to all of this.  I've been sitting here today listening and agreeing that I truly am a full-fledged CC.  Conversely, in my last...

Look at the changes they did in 2016... they made it so that all files in Temp DB suffer the equivalent of TF 1117 to force all files to grow...

Congrats on the license upgrade. one more level to go.

We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better...

If it is an issue of trailing control characters - you could also use SUBSTRING or LEFT to truncate the string and convert:

SELECT cast(substring('16.3%'+CHAR(10), 1, charindex('%',...

Ah... one more thing... REPLACE can make sucking sounds for performance even if the default collation is used.  It's performance can usually be increased by quite a bit when you're...

First of all, the LTRIM/RTRIM thing might just be a waste of clock cycles... the following works just fine.

 SELECT CAST(ISNULL(REPLACE(SPACE(10)+'16.3%'+SPACE(10), '%', ''), 0) as FLOAT);

I suspect...

Congrats on the license upgrade. one more level to go.

We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better or cheaper...

On a different note, here's one of the many reasons I fear both the cloud and any automatic performance metrics collected by any company...

https://mspoweruser.com/microsoft-accidentally-exposes-250-million-customer-support-records-online/

This has gotten to be a totally...

Have you checked to see if a virus scan is running and maybe picking up on the Access files?

I've trimmed the values, removed the '%' and I still cannot convert or cast these values.  Since I can't change the table structure, I am stuck doing this in...