Reported By: Arnd Baranowski Reported On: 3/2/2008 For: Version 1.08 Build 1
# 2561Using LIKE in a Correlated Sub-Query On Correlated Columns Can Cause Incorrect Results The following syntax does not work. "POS" also does not work in an Update statement. The first found value is set to all rows.
Update Code_Map Set
MappedRate = (SELECT Rate from ebc_rates_cw WHERE
Code_Map.Dialcode like (ebc_rates_cw.Dialcode + '%'));
Workaround:
Update Code_Map Set
MappedRate = (SELECT Rate from ebc_rates_cw WHERE
ebc_rates_cw.Dialcode = left(Code_Map.Dialcode,4));
Comments and WorkaroundsThe workaround is as noted.
ResolutionFixed Problem on 3/4/2008 in version 1.09 build 1