Luther1978
Technical User
I'm in the process of writing a Function to be used in a view, After many atempts I simplified the fucntio to this:
CREATE FUNCTION FindWeekNo
(@StartDate as datetime)
RETURNS char
AS
BEGIN
DECLARE @temp as char
SET @TEmp = 'Hello'
RETURN @Temp
END
My problem is whatever function I use in my view I only get the first character Returned. In the above case "H"
Other Functions I have tried where I getting only the first number of the year returned ie. 2
Many Thanks in Advance
Martin
CREATE FUNCTION FindWeekNo
(@StartDate as datetime)
RETURNS char
AS
BEGIN
DECLARE @temp as char
SET @TEmp = 'Hello'
RETURN @Temp
END
My problem is whatever function I use in my view I only get the first character Returned. In the above case "H"
Other Functions I have tried where I getting only the first number of the year returned ie. 2
Many Thanks in Advance
Martin