Arthur Fuller
artful at rogers.com
Wed Feb 19 19:07:00 CST 2003
UPDATE mytable SET myColumn = IIF( Right(myColumn,1) = "8", Left(myColumn,Len(myColumn)-1), myColumn) That should work in Jet. For SQL Server you have to use CASE WHEN THEN. Hth, Arthur -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Paulin Hudsen Sent: February 19, 2003 7:47 PM To: accessd at databaseadvisors.com Subject: [AccessD] Remove last Letter Hi, I have a column in my Fixed Assets List. The column has The Asset Number. Many of the asset numbers end with 8. Now I am requested to remove the 8 if it is the last digit. How can I do that using an update query. Thanks Paulin __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com