Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. davcomp

    How do I update a single byte within a field using an embedded sql.

    I am trying to change a single byte(pos.59) within a 100 byte field(group_formactions). The following code produces an error when it is compiled. I know the syntax is not right on the lines within the sql portion where I am trying to do the update. How can I fix it? Thanks in advance...
  2. davcomp

    What is the best way to update a single character in a 20 byte field?

    Thanks for everybody's help!! Both the (left & right) and (stuff) functions worked.
  3. davcomp

    What is the best way to update a single character in a 20 byte field?

    I need to change a single character in a 20 byte field. I tried using the SUBSTRING operation but when I run it I lose everything in the field. I don't think I have the syntax right. My table name is SECGROUP. group_id x(10) group_actions x(20) exp_days x(03) I need to change...

Part and Inventory Search

Back
Top