in my web (asp.net+vb code and sql 2005 database) i have a grid view for that i use this function is as under
USE [ANIL]
GO
/****** Object: UserDefinedFunction [dbo].[getytodtCount] Script Date: 10/20/2012 10:13:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[getytodtCount]
(
@ENTRY_COURSE as varchar(50)
)
RETURNS varchar(max)
AS
BEGIN
DECLARE @Count VARCHAR(MAX);
select @Count = case
when(ENTRY_COURSE NOT LIKE 'WS%' AND ENTRY_COURSE NOT LIKE 'SSCW(T%'AND ENTRY_COURSE NOT LIKE 'TES%') AND DTSEN<>DTCOM then convert (varchar,DTCOM+761,6)
else convert (varchar,DTCOM+396,6) end
from course_intake where
entry_course = @entry_course
RETURN @Count
END
I WANT TO AMMEND TH ABOVE FUNCTION ( I WANT TO ADD THE BOLDED PORTION IN THE ABOVE FUNCTION
ENTRY_COURSE NOT LIKE 'WS%' AND ENTRY_COURSE NOT LIKE 'SSCW(T%'AND ENTRY_COURSE NOT LIKE 'TES%') AND DTSEN<>DTCOM then convert (varchar,DTCOM+761,6)
ENTRY_COURSE LIKE 'TES%' then convert (varchar,DTCOM+1125,6)
else convert (varchar,DTCOM+396,6)
