If the table you select from contains memo field, you can use something like:

sele substr(MemoFiledNAme,100000,1) as blank_memo from...

>I'm pretty sure I knew how to do this at one time, but now... All I want to do >is select an empty memo field in a select statement (like doing '' or 000 for >character and numeric. I know that I can use create table, but I really want >to have it in the SQL. It's easy, right? Thanks!