SQL SP/func modification
Budget: $10 – $30 USD
The candidate will do a screen share with me to look over the data and solution and successfully test the process.
It's an sp/function that outputs:
<b>REDUCE DEPTH-BASE </b><br>, 17, 3/16
What I want it to output is: replace("," with "TO: " then "Inches" to be at the end of the string. If there is no fraction, then inches would follow the whole number.
This change is only to be done when the configuration option is for inches/Fractions... I can explain more in detail if we meet.
so if the output is this:
<b>REDUCE DEPTH-BASE </b><br>, 17, 3/16
then the output would be:
<b>REDUCE DEPTH-BASE </b><br>TO: 17 3/16 Inches
and if the output is this:
<b>REDUCE DEPTH-BASE </b><br>, 17
then the output would be:
<b>REDUCE DEPTH-BASE </b><br>TO: 17 Inches
It's an sp/function that outputs:
<b>REDUCE DEPTH-BASE </b><br>, 17, 3/16
What I want it to output is: replace("," with "TO: " then "Inches" to be at the end of the string. If there is no fraction, then inches would follow the whole number.
This change is only to be done when the configuration option is for inches/Fractions... I can explain more in detail if we meet.
so if the output is this:
<b>REDUCE DEPTH-BASE </b><br>, 17, 3/16
then the output would be:
<b>REDUCE DEPTH-BASE </b><br>TO: 17 3/16 Inches
and if the output is this:
<b>REDUCE DEPTH-BASE </b><br>, 17
then the output would be:
<b>REDUCE DEPTH-BASE </b><br>TO: 17 Inches