simple sql questions

Question 1.

I want to do something like this:

select * from mytable where mycolumn='ABC*';

                                         ^


					 |

					 |

                           match anything that starts with ABC

Is this possible?

Question 2.

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?

Thanks in advance Received on Tue Sep 07 1993 - 20:51:03 CEST