Filter not working proeprly

• PSB

  SSChampion

  Points: 13195

  More actions

  September 18, 2009 at 9:57 am

  #226311

  I am trying to filter my query with Region.

  I have some NULL values for the RegionName . Thats why I did something like this :

  ISNULL(Reg.RegionName,'No region assigned') RegionName

  In my stored proc I set Region as a parameter . When I execute the sp with parameter 'No region assigned' , it doesnot return any values although it returns results for all other regions .

  Any help appreciated .

  Thanks.

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  September 18, 2009 at 10:14 am

  #1055721

  Please post the stored procedure code.

  Without that, any suggestions will have to be based on pure guesswork.