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:340104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
