Update only a particular position in a field 1

[storm75m]

I need the SQL syntax of how to update only the 25th position within a particular field. For example, I have a text field named USDATA in table named UBUCTL with data like this:

" Y YY N YYY NN 000000000 YN"

and I need to place an "N" in the 25th position of every record, but leave the rest of the data unchanged. I would like to be able to do this with one simple SQL statement instead of using code to loop through records. Any help would be much appreciated, code samples would be awesome. Thanks geniuses!

 

[lespaul]

First run a Select query and see if you get the information you need:

SELECT FieldName, mid(FieldName, 1, 24) & 'N' & mid(FieldName, 26, len(FieldName)) As NewValue From TableName

if that gives you the correct information, you can use this update query:

Update tblName Set FieldName = mid(FieldName, 1, 24) & 'N' & mid(FieldName, 26, len(FieldName)

Leslie

 

[lespaul]

missing a paren:

Update tblName Set FieldName = mid(FieldName, 1, 24) & 'N' & mid(FieldName, 26, len(FieldName))

Leslie

 

[storm75m]

worked great thanks.

 

[lespaul]

no problem, thanks for the star!!


Leslie