Re: How can I select all IDs from a Column, when I dont have any Values

> I am looking for a Asterix like % for the Number Datatype.
>
> Example:
>
> For a Varchar-Column:
> select id, name from table where name like '%';
>
> For a Number-Column:
> select id, name from table where id = ????

select id, name from <table> where to_char(id) like '13%'

hth
Rene

-- 
Recherchen im schweizerischen Handelregister: 
http://www.adp-gmbh.ch/SwissCompanies/Search.php3