Looking for help in setting up the Parameter where the data enter is less than the expected field length

[Linda_Hankemeie]

I have a new dashboard that I set up to return based on the PO Number entered in parameters.  My issue is the field length in the database is varChar14 but most often the field is between 4-6 characters.   

If I enter "3777" in the parameter nothing is returned if I enter "          3777" the expected data is returned.   Is there a way to get this to return with the "3777".

In the dashboard I set the rule to be PO_NUMBER Ends with PO_NUMBER but I'm still not seeing my expected results.

Any recommendations?  Thanks much!

Linda 

[Linda_Hankemeie]

UPDATE: This was resolved by using this WHERE Clause

WHERE LTRIM(RTRIM(PO_NUMBER)) = @{PRIMARY}