Both fields are varchar

Datatype is varchar and the field always begins with the x

My requirements changed and I was able to use a Function to sum the deal totals. Thanks for the help.

I need to get the query to do the join when executing so the result set would a row for each deal value with the id repeating

ID Dealvalue

1 ...