>>I see, never mind then. I wanted to help someone by easier way. I'll play at night myself.
>
>Look up convert: select convert(char(8), schrun, 108) as mytime from msgschdl
>
>works for me (the datetime column is schrun and the table is msgschdl)

Very nice, thanks, Tracy.

declare @test table (myValue varchar(max), dt datetime)

INSERT INTO @Test (MyValue, dt) 
VALUES ('adddd', GETDATE()),
 ('bgfgfg', getdate()-10),
 ('bgfgfg', getdate()-15)

SELECT convert(char(8), dt, 108) as mytime 
FROM   @Test where myValue > 'a' and myValue < 'mzzzzzzzzzzzzzzzzzzzzzzzzz'