Posted by --CELKO-- on 10/03/06 20:56

CONSTRAINT no_white_space
CHECK ( LEW(foo) = LEN (REPLACE (foo, ' ', '')))

You can then nest calls to REPLACE() for tabs,newlines, etc. easily.

• Next in forum: Date overlapping
• Prev in forum: Problem Copying Table
• Thread view: Re: Best way to force a varchar column to have no whitespace

[Reply to this message]