I am getting the values from a separated comma list(see syntax below) If I can just multiply the value times .01 that would be sufficient.

STUFF(( SELECT ', '...

Thanks for the reply. hard coding the values is not something that I want to do as this values can change without notice. As I continued to scavange the internet,...

thanks for the reply!

I google split function and found the following function that gets me on my way but I'm having trouble trimming it so I only get the values...