Re: like no me devuelve registros

From: Manuel Diego <manuel(at)radiohead(dot)cl>
To: suso <jlcubas(at)terra(dot)es>
Cc: PostgreSQL <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: like no me devuelve registros
Date: 2009-11-20 14:27:55
Message-ID: EFEB4B7D-B390-41FD-873D-E47B66CB53D6@radiohead.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

cadena_auxi = "SELECT nombre,apell,apell2,NIF from cli where
upper(apell) LIKE upper('" & INICIAL & "%') order by apell LIMIT 70
OFFSET 140;"

Ojo con las comillas simples y dobles.

El 20-11-2009, a las 11:20, suso escribió:

> cadena_auxi = "SELECT nombre,apell,apell2,NIF from cli where
> upper(apell) like '" & Trim(UCase(apelli(0).Text)) & "%' order by
> apell LIMIT 70 OFFSET 140;"

------------------------
Manuel Diego Paillafil Gamboa
manuel(at)radiohead(dot)cl

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message suso 2009-11-20 15:01:20 Re: like no me devuelve registros - solucionado
Previous Message suso 2009-11-20 14:20:47 like no me devuelve registros