Trying to use ESCAPE

From: Wessel R.J. Koornstra <Wessel.Koornstra_at_psb.nl>
Date: Thu, 17 Jun 1999 16:07:20 +0200
Message-ID: <37690118.53A5839C@psb.nl>

Hi,

I'm trying to use the escape command to get a row from a table. The query is supposed to get strings beginning with 1,2,3,4,5,6,7,8 or 9.

I tried the following but it didn't work because after the first escape sign there seems to be missing something.

select column1 from table
where column1 LIKE '/[0-9/]%' escape '/';

If somebody could help me I would be very thankful.

Yours

Wessel Koornstra Received on Thu Jun 17 1999 - 09:07:20 CDT