Re: How to select column with one or more spaces

> select col_name from tab_name
> where col_name = ' ' or col_name = ' ';

You only select columns with one or two spaces.

But

SELECT col_name FROM table_name

   WHERE INSTR(col_name,' ') >= 1;

will select every column (or rather rows containing this column) with one or more spaces.

Regards,

Knut Received on Fri Jul 06 2001 - 07:38:14 CDT