var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: update query question
Hello, I have a field that I need updated. The data in the field is in the following format: "024840100". I need to update the data so that it displays like this: "0100-02484".
Can anyone provide me the the syntax to use to make this change?
Thank you very much,
If the format is fixed, you can try this:
Assuming strX is 024840100:
dim strA as string
dim strB as string
dim newStr string
strA = right$(strX, 4)
strB = left$(strX, 5)
newStr = strA & "-" & strB