>Dear Sirs,
>
>Regards & Hello
>
>I want a small prog or solution to clean a string which will remove all things execpt numbers and Alphbets.
>
>e.g:
>
>Original string is "abcd ## 55 JJJ )))345 )) +++++"
>Result I should get: "ABCD55JJJ345"
>RESULT IS IN UPPERCASE:
>
>
>EARLY REPLY IS APPRICIATED.
>
>RAHUL


Rahul: Try with:

lcChar = "1245&%TTFH&%$fgf+gfgd66%%$$#0045"
? UPPER(CHRTRAN(lcChar,CHRTRAN(UPPER(lcChar), ;
   "01234567890ABCDEFGHIJKLMNÑOPQRSTUVWXYZ",""),""))