Hello again,

ONE LITTLE SQL PROBLEM with a stored procedure :|.
I'm receiving the error *Invalid character value for cast specification* 
(see stored procedure below)


CREATE PROCEDURE pv_EventsDate
@BeginDate datetime
AS
.............
..................

WHERE     ((dbo.tblEvents.BeginDate >= GETDATE()) OR
                      (GETDATE() BETWEEN dbo.tblEvents.BeginDate AND
dbo.tblEvents.EndDate)) AND ((dbo.tblEvents.BeginDate like @BeginDate) OR
(@BeginDate BETWEEN  dbo.tblEvents.BeginDate And dbo.tblEvents.EndDate))
ORDER BY dbo.tblEvents.BeginDate
GO

thnx so much Evan