How to update part of a field?
Posted: Sat Sep 24, 2005 2:46 pm
I have a large DB where I would like to change fields beginning with "BA" to "Ba".
The records typically have more information, like "BA 1234567". I would like to change this to "Ba 1234567".
How to I compose an SQL query to search through records, find those that start with "BA" and change only that part to "Ba"?
The records typically have more information, like "BA 1234567". I would like to change this to "Ba 1234567".
How to I compose an SQL query to search through records, find those that start with "BA" and change only that part to "Ba"?