try ... where blah_col=blah_col (just put the column name in the & variable). On 8/15/07, Lyall Barbour <lyallbarbour@xxxxxxxxxxxxxxx> wrote: > > Hey everybody, > This is probably something easy and simple i'm missing. I'm using the > & in the WHERE clause of a query to get certain information. How do i get > ALL the information, too. Essentially, blanking out the where clause. > > select blah_col > from blah_table > where blah_col = &blah_variable; > > When the prompt comes up, if i just want all in info, is it possible to > get this? I just hit enter and didn't work. > > Lyall > > > -- We've Got Your Name at > Mail.com<http://www.mail.com/?utm_source=mail_sent_footer&utm_medium=email&utm_term=070621&utm_content=textlink&utm_campaign=we_got_your_name> > Get a *FREE* E-mail Account Today - Choose From 100+ Domains > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'