Re: usando like

On 12/2/05, AUGUSTO ESTEBAN <augustin_hm(at)yahoo(dot)es> wrote:
>
>  saludos lista,
> estaba probando algo de like y primera vez que me encuentro en esta
> incognita,
>
> WHERE ubigeo_domicilio like '%0501%'
>
> eso me devuelve cuaquier patrron que coincida con 0501, pero como puede
> hacer para que me devuelva "lo que no coincida con ese patron"???
>

con not like

salu2
gonzalo

>
>
> --
> When things are investigated, then true knowledge is achieved;
> when true knowledge is achieved, then the will becomes sincere;
> when the will becomes sincere, then the heart sees correctly;
> when the heart sees correctly, then the personal life is cultivated;
> when the personal life is cultivated, then the family life is regulated;
> when the family life is regulated, then the national life is orderly;
> and when the national life is orderly, then there is peace in this world.
>
> Confucius