Aman,
Tuesday, April 09, 2002, 5:24:49 PM, you wrote:
AR> Hello everyone
AR> I want to alter 50 tables, and for each the names start with the string
AR> 'mak'
AR> Is there an SQL query, so that I can do the change in one command.
AR> I have tried using wildcards - they don't seem to work in SQL.
Wild cards do work, but you have to make sure you use the right type. SQL
uses % and I believe _ as
wild cards. I know if you wish to use them in SELECT statements it would
look like: SELECT *
FROM pet WHERE name LIKE "b%" this would return anything from pet where
the name starts with ab.
Go look
Hello everyone
I want to alter 50 tables, and for each the names start with the string
'mak'
Is there an SQL query, so that I can do the change in one command.
I have tried using wildcards - they don't seem to work in SQL.
Thanks in advance.
Aman
_
