Thread: query varchar fields by length
Is it possible to select rows from a field based on the length of the data in a varchar field? Thanks -r Ryan Mahoney CTO, Payment Alliance, Inc. ryan@paymentalliance.net t. 718-721-0338 m. 718-490-5464 www.paymentalliance.net --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.250 / Virus Database: 123 - Release Date: 4/18/01
Ryan Mahoney wrote: > > Is it possible to select rows from a field based on the length of the data > in a varchar field? length works fine in a select on a varchar field. select a from b where length(a)=5; You didn't ask for this, did you? Grabbing different columns depending on values of another another column can be done with "case": select case when length(col_var)<5 then col_a when length(col_var)>5 then col_b else col_5 end from tbl ; With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitter holger@klawitter.de http://www.klawitter.de