November 30, 2001 at 3:50 pm
Does anyone know how to use the formula in the design tbl (sql 2000), need to default a column to 'U' if input data is ' '(space) during insert, i tried something like IIf(column_name = ' ','U','U') and got an error. do not want to use trigger. Thanks for quick response
November 30, 2001 at 5:37 pm
First create and test a function that does what you need, maybe something like this:
IF EXISTS (SELECT *
FROM sysobjects
WHERE name = N'test_function')
DROP FUNCTION test_function
GO
create FUNCTION test_function
(@p1 varchar(10))
RETURNS varchar(10)
AS
BEGIN
declare @Temp varchar(10)
if @p1 =' '
select @Temp='U'
else
select @Temp=@p1
return @Temp
END
GO
Next, in the formula, enter this (based on the above example and assuming that whocares and col3 are varchar cols in the table):
([dbo].[test_function]([col3]))
Could you explain why this will work out to be a better solution than a trigger? Are you planning to index it? Just curious!
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy