There's probably a better way to do this, but this is what occurred to me:
select
max(
len(
rtrim(
replace(
substring(
cast(position as varchar(50))
, charindex(
'.'
, cast(position as varchar(50)))
, 50)
, '0', '')
)
)
)
from ...
Monday, June 25, 2007
Tuesday, June 5, 2007
Subscribe to:
Posts (Atom)