Formatted Search not working..

Hi SAP Gurus,

i have created a Formatted Search for Business Partner. below is the code.

select top 1 LEFT(cardcode,2)+ RIGHT(CAST(000 + (10001+ right(cardcode,4)) AS varchar(5)), 4)

from OCRD

where CardType = $[OCRD.CARDTYPE] -- 's'

and CardCode LIKE $[%OCRD.CARDCODE.CHAR(1)%]

order by CardCode desc

the out put of the query should be : 'VU0010'

but bad luck its not working.. does any one know the proper query ..?

i appreciate your help.

Thanks and Regards,

kaviprashu