SELECT based on field string length 1

[jimoblak]

Is it possible to make a selection based on the length of the string in a field?

I have a text field that is supposed to be 4 characters long. Some fields incorrectly imported with 3 characters. I need to locate these shorter strings to place/pad a 0 at the start of the string.

Example data:
312
311
1211
S210

should be:
0312
0311
1211
S210

Is there some magical SQL to locate these 3-character strings and/or add the leading zero?

- - picklefish - -

 

[swampBoogie]

update t 
   set c = concat('0',c)
 where char_length(c) = 3