Trim result in function

• bracaqcp

  Newbie

  Points: 1

  More actions

  December 13, 2003 at 4:03 pm

  #162750

  i have this function so thet i could easily get name of countries in english or in german

  CREATE FUNCTION vNationality ( @lang VARCHAR(3) )

  RETURNS @vNationality TABLE

  (

  PK INT,

  FKArea INT,

  Country CHAR(30)

  )

  AS

  BEGIN

  IF @lang = 'ENG'

  INSERT @vNationality

  SELECT PK, FKArea, RTRIM(CountryENG) AS Country

  FROM Nationality

  IF @lang = 'GER'

  INSERT @vNationality

  SELECT PK, FKArea, RTRIM(CountryGER) AS Country

  FROM Nationality

  RETURN

  END

  GO

  but Country field is not trimmed.

  Does enyone have a solution?

• mbarrentine

  SSC Enthusiast

  Points: 102

  More actions

  December 14, 2003 at 1:57 pm

  #486075

  Try changing

  Country CHAR(30)

  to

  Country VARCHAR(30)

• sscbm21

  Old Hand

  Points: 323

  More actions

  December 14, 2003 at 10:28 pm

  #486094

  Char is for Fixed length, so Trim functions(LTRIM, RTRIM) has no role to play. mbarrentine has given the right suggestion.

  bm21

  
  bm21