Dude! that looks like exactly what I need:
convert(varchar, convert(int,(field * 100))) + '%' + '%'
Thnx :-(
But when I put in my query and replace field - I get a syntax error.
:-(
I am using MySQL 3.23.58
The Documentation I find on CONVERT though has a slightly different syntax. I don't find an example of CONVERT used to change data types - only encoding types:
CONVERT(expr USING transcoding_name)
.