Hoi Gail ,

thanks for the response. ik did like you told and created a table where the content of the errorlog is in. now i am struggeling with a query to get only those lines with the logdate = current date. i have seen that you've got to do something with cast, but would appreciate for some help with this one.

thanks in advance

this is the simple table i created:

create table #errorlog

(logdate datetime,

processinfo nchar(30),

info nchar(2000))