1 Dec 2006 at 17:22 #1 fluiduk fluiduk Associate Joined 13 Nov 2003 Posts 1,568 Location Manchester Hi Guys Could anyone help me with the syntax for a query that deletes all records that begin with a certain character? Any help appreciated Thanks
Hi Guys Could anyone help me with the syntax for a query that deletes all records that begin with a certain character? Any help appreciated Thanks
1 Dec 2006 at 17:29 #2 meghatronic meghatronic Soldato Joined 24 Nov 2002 Posts 16,376 Location 38.744281°N 104.846806°W fluiduk said: Hi Guys Could anyone help me with the syntax for a query that deletes all records that begin with a certain character? Any help appreciated Thanks Click to expand... Use Like %%
fluiduk said: Hi Guys Could anyone help me with the syntax for a query that deletes all records that begin with a certain character? Any help appreciated Thanks Click to expand... Use Like %%
1 Dec 2006 at 17:29 #3 toString toString Soldato Joined 18 Oct 2002 Posts 9,135 Location London delete from table where row like 'K%'
1 Dec 2006 at 17:31 #4 fluiduk fluiduk Associate OP Joined 13 Nov 2003 Posts 1,568 Location Manchester Thanks guys will give it a whirl Aaron
