Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete from question

Status
Not open for further replies.
philk12

philk12

Programmer
Dec 29, 2005
20
US
Hello,

Is this the correct way to write an embedded sql "DELETE FROM" statement with a wildcard?

delete from xxx where ACITY not like :BCITY || '%'
 
Sort by date Sort by votes
Code: 
delete from xxx where ACITY NOT LIKE [:BCITY || %]

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

crashmaster18
  • Question
Newbie Report Designer Question: Changing Report Label content based on Checkbox Value in table
Replies
6
Views
223
Chris Miller
Chris Miller
SitesMasstec
  • Locked
  • Question
Combobox populated with data from a table 1
Replies
8
Views
1K
igorsandler
igorsandler
BugZap13
  • Question
Quickbooks QBFC16 SDK 64 bit usage from VFP9/VFPA
Replies
1
Views
219
GTGeek88
GTGeek88
bs6600
  • Locked
  • Question
append from tab delimited - intersting effect (or bug)
Replies
14
Views
716
Chris Miller
Chris Miller
David Higgs
  • Locked
  • Question
Strip leading characters from a string 3
Replies
15
Views
1K
David Higgs
David Higgs

Part and Inventory Search

Sponsor

Back
Top