Take a look at PATINDEX

UPDATE [tableName]

SET [datetimeColumnName] = NULL

WHERE [datetimeColumnName] = 'dateTime'

AND [firstColumn] = 'someDataHere'

This will "delete" the data in that one row's specific column.

+1 🙁

I was one of the people who got it wrong... <facepalm/>

Even without reading the explanation, I realized my error... maybe I should drink my first cup of...

Foiled again!

Interestingly, what is on MSDN and what is in BOL is not the same! Though, I suspect what is on MSDN to be more accurate...

Great question, I have...

This is my 2 cents, but I searched through BOL (my usual default starting location for answering TSQL questions) on both LEN and REVERSE and neither helped in the "correct"...

Typically I would add the SQL here but I'm running into a meeting...

You could join the CTE to itself (aka make it recursive) but join each row to ROW# -...

Or another approach (but extremely similar):

select IDXMRN,Problem,Code

from dbo.Diagnosis

where LEFT(CODE,3) = '491' OR LEFT(CODE,5) = '305.1'

Did you check out this blog: http://www.sqlservercentral.com/blogs/discussionofsqlserver/2012/02/15/comparing-inline-and-multistatement-table-valued-functions/? According to BOL, an inline function is a single statement, if you need to create variables then it sounds like you might need...