Looking Up Records That have % in Field Data

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Looking Up Records That have % in Field Data

Message

26/09/2008 12:08:20

26/09/2008 12:00:19

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Versions des environnements

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

Windows 2008 Server

Database:

Visual FoxPro

Divers

Thread ID:

01350997

Message ID:

01351000

Vues:

>I am needing to do a SPT to find part numbers that have a % in them. Since this is the wildcard symbol haw would I write the sql string?

select * from myParts where partnumber like "%\%%" escape "\"

Cetin