Hello this is my second post and I am fairly new to SQL. Really what I am trying to find is an equivilent to MID$ or InStr from VBA where I can make updates based on part match of a field.
I cobled together the code below from net searches but alas it didn't work.
WHERE '2008' like ('%' || UpdateField) AND KeyField='1'
In other words I wand to update to 'Text-2008-001-old' where the field might currently be 'Line-2008-000-000'
The position of the 2008 does not change within the existing data so really I just need to update and fields that contain 2008 where the KeyField is '1'
If there is a good online resource for SQL syntax that I have not found yet please feel free to point me there.
Hope I have explained this OK and thanks in advance for all suggestions.