This is a question that has been often asked and the (sad) answer is "no"!

Read a couple of these other threads for info...

what error msg do you get ?! I don't know anything about RS, but if your values are integers then try using the ISNUMERIC() function instead and see if that...

wow Phil - you're also in charge of "missing persons bureau"...impressive! Is there no end to your knowledge base ?!?!

I'm still curious about how this would work when "@intContactCategory is null" given the t-sql & where clause in the first post (unless it has been changed to follow PW's...

Haven't looked at the DDLs yet, but in your where clause, you're not using a column name...

"where

(@intContactCategory is null or U.pk_intUserID in (select CC.fk_intUserID from dbo.tblContactCategories_Users CC where CC.fk_intContactCategoryID...

Marce - I think this is what you're looking for...the program_name will give you the application via which the users are accessing the database...

select login_time, hostname, program_name, nt_username from...

One alternative is to have a drop-down box that displays the values from your "Specialty" table where the user can select multiple rows and then you insert based on the...

yup - rtrim is much better - for some reason I was confusing it with right() which requires 2 arguments...

something like this (if you're updating only one row at a time)...

CREATE TRIGGER trgInsertIntoHistory ON [dbo].[tblTestRequest] 
FOR UPDATE
AS

BEGIN
INSERT INTO tblHistory
SELECT col1, col2 FROM Deleted
END

You will have to check the "Deleted" table for the values that you want to insert into your history table...based on the TestRequestNo...

You could do a replace (below..) but why bother when you can just trim during display ?!?!

declare @trimString as varchar(10)
set @trimString = 'boo     '
select @trimString,...

Ya - I was going to ask if you've tried explicitly specifying all column names (in your insert statement)!!! - glad you got it working!

WOW...how did you even come up with this query ?!?! I think sample data, output AND a brief explanation of requirements would not go amiss!

It's your "Projects" table that seems to have the identity column...you'll have to explicitly..

SET IDENTITY_INSERT Projects ON

...insert data...........

SET IDENTITY_INSERT Projects OFF

You will also have to explicitly specify the column names...

is this what you want ?!

"select convert(varchar, dateField, 101) as formattedDate from myTable"