Can you cast is as a numeric value, all entries with '0000' should turn into 0, while anything with number becomes Null? then you simply check WHERE CAST() = 0
Regards, David McGraw Oyova Software, LLC - http://www.oyova.com On Fri, Dec 17, 2010 at 2:18 PM, Ian Skinner <h...@ilsweb.com> wrote: > > I have a varchar field that can (shouldn't, but can) contain a > variable number of zero[0] characters. > > I want to return all rows where this field only contains zeros, no > matter how many zeros it may contain. > > Due to too much holiday potluck, my lethargic brain can not produce even > a glimmer of an idea of a concept for this. > > TIA for any suggestions or guidance. > > Ian > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm