remove record from SQL database

The table FormDefinitions have the following:

(<xaoFormID, char(75),>
           ,<xaoControlName, char(70),>
           ,<xaoClassID, char(35),>
           ,<xaoType, numeric(1,0),>
           ,<xaoProperties, text,>
           ,<xaoCode, text,>)

I would like to delete the following records
where xaoFormID like '%FSIPVSTR09%'  and (xaoControlName like '%chkelecpckupg%' or xaoControlName like '%cmdelecpckupg%')

Open in new window


I've been using SQL Server for about 5 months and never had to delete any records.

So, what is the the best way to do this via SQL Statement?

THANKS.
jeremyllAsked:
Who is Participating?
 
celdridgeMadmanConnect With a Mentor Commented:
delete from FormDefinitions where xaoFormID like '%FSIPVSTR09%'  and (xaoControlName like '%chkelecpckupg%' or xaoControlName like '%cmdelecpckupg%')

Just be careful when deleting obviously!
0
 
vdr1620Connect With a Mentor Commented:
Be sure of what you want to delete...I would you to go through these articles before you delete the data from the table..

http://msdn.microsoft.com/en-us/library/ms189835.aspx
http://www.sql-tutorial.net/SQL-DELETE.asp
http://www.sql-tutorial.com/sql-delete-sql-tutorial/
0
All Courses

From novice to tech pro — start learning today.