thanks Jack

Is that the option that I should take whenever this problem arises

thanks guys actually solved the problem in the app. Was tryng to write a query that wouldnt have worked

thanks for the replies .My problem is now solved

thanks Jeff. the select statement returned 9 which i believe means tab character. Strange because the text file wasnt tab delimited as far as i can see. The replace function...

thanks for the info chris

create table OrderDetails(

 OrderID int not null REFERENCES Orders(OrderID)on delete cascade,

 ProductID int not null REFERENCES Products(ProductID),

 OrderedDate smalldatetime not null CHECK (OrderedDate>=datepart(day,getdate())),

 Quantity int not null DEFAULT 1,

 UnitPrice money not null,

 RequiredDate smalldatetime null...

create procedure DeleteOrder

@OrderID int

AS

if not exists(select*from Orders where <A href="mailtorderID=@OrderID">OrderID=@OrderID)

BEGIN

RAISERROR('The selected order was not made',16,1)

RETURN     

END

update Products  set UnitsInStock=UnitsInStock+

(select Quantity from OrderDetails where...

I dropped the delete trigger which is below as i only needed it to update my products table. But because i tried to move the code into a stored procedure...