• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

Change in Char Size

I have a backend Sybase Central, Front End MS Access 2000

I had a table tblBadge, there is a field in the table named "BadgeNo" Char (6), not null, unique.

Badge No starts with "W", I am now at W99999 so I changed Char size to 7 and relinked the tables. When i search through the front end I no longer get the records.

Example
I serach for W70000, no record
I add an extra 0 to the record W700000 and I get teh record.

It seems like now that I have added an extra value size to BadgeNo it is looking dfor an extra digit.

Help, confused
0
Brogrim
Asked:
Brogrim
1 Solution
 
kaylanreilorCommented:
A '0' has been concatenized at the END of each existing record to match the new size.
Now you need a script that you have to run against your table to "move" this '0' just after the 'W'.
Former W71234 has become W712340 instead of W071234.
0
 
BrogrimInformation Systems Development ManagerAuthor Commented:
Whe you sday a script do you mean an append or update query
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now