Query Runs Fine In Query Analyser But Not The Query Debugger

I'm running a query, actually its an insert that works when using the TSQL below.





However when I try to use the debugger to step through and using the exact same values as those below I get the following error:





[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification





Its Killing me because everything else works, but this. Can somebody help.








DECLARE @NoteID INT,-- NULL OUTPUT,


@Note_Description NVARCHAR(3000),-- = NULL,


@Date DateTime,-- = NULL OUTPUT,


@ByWho NVARCHAR(30),-- = NULL,


@FK_Action_Performed NVARCHAR(40),-- = NULL,


@FK_UserID INT,-- = NULL,


@FK_JobID INT,-- = NULL,


@Job_Date DateTime,-- = NULL,


@Start DateTime,-- = NULL,


@Finish DateTime,-- = NULL,





@BeenRead NVARCHAR(10),-- = NULL





@FK_UserIDList NVARCHAR(4000)-- = NULL








--SET @NoteID = 409 --NULL OUTPUT,


SET @Note_Description = 'Tetsing'


--SET @Date DateTime = NULL OUTPUT,


SET @ByWho = 'GeorgeAgaian'


SET @FK_Action_Performed = 'Worked hard'


SET @FK_UserID = 5


SET @FK_JobID = 29


SET @Job_Date = 28/01/03


SET @Start = '1:00:20 PM'


SET @Finish = '1:00:20 PM'


SET @BeenRead = 'UnRead'





SET @FK_UserIDList = '1,2,3'








--AS





--SET NOCOUNT ON








SET NOCOUNT ON





SET XACT_ABORT ON





BEGIN TRANSACTION





SET @Date = GETDATE()





-- Insert Values into the customer table


INSERT Note (Note_Description,


Date,


ByWho,


FK_Action_Performed,


FK_UserID,


FK_JobID,


Job_Date,


Start,


Finish)





SELECT --@NoteID,


@Note_Description,


@Date,


@ByWho,


@FK_Action_Performed,


@FK_UserID,


@FK_JobID,





@Job_Date,


@Start,


@Finish





-- Get the new Customer Identifier, return as OUTPUT param


SELECT @NoteID = @@IDENTITY








-- Insert new notes for all the users that the note pertains to, in this case this will be by the assigned


-- users.


IF @FK_UserIDList IS NOT NULL


EXECUTE spInsertNotesByAssignedUsers @NoteID, @FK_UserIDList





-- Insert New Address record


-- Retrieve Address reference into @AddressId


-- EXEC spInsertForUserNote


-- @FK_UserID,


--@NoteID,


-- @BeenRead


-- @Fax,


-- @PKId,


-- @AddressId OUTPUT





COMMIT TRANSACTION





--------------------------------------------------


GO