Re: simple sql questions

In <26il6n$9lh_at_elroy.jpl.nasa.gov> jason_at_woody.uucp (Jason Yi) writes:

>Question 1.
 

>I want to do something like this:
 

>select * from mytable where mycolumn='ABC*';
> ^
> |
> |
> match anything that starts with ABC
 

>Is this possible?

Yes, try select * from mytable where mycolumn like 'ABC%'

>When you have a foriegn key, does the child table make a copy of it's
>parent's or does it have a pointer referencing to it's parent?

To misquote Firesign theatre: "No, No, No, you don't understand how radio works!"

Child tables don't have pointers, or copies. Neither do parent tables. It's the _query_ which links the tables, not the database itself. This is the key to relational databases.

Dave
>Thanks in advance

-- 
David Benua                  Internet: dbenua_at_panix.com 
	                   Compu$erve: 72630,1416