How To Format Text With Special Charters?

[scottdev]

I want to run an update query on a field that is currently "text".

I need to update the number that is currently there:

From:
"12"

To:
"field=Issues-Yr&&&value=12"

and some fields to:

"field=Issues-Yr&&&value=12###"

Is there some special way I need to format the field in terms of data type, validation rule, validation text, etc and/or combination of charters around the information I want to use in the update query?

 

[PHV]

Just be sure the field length is sufficient and that no validation rule is defined for it.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244