View Single Post
  #1 (permalink)  
Old 09-07-2006, 07:31 PM
Michael
 
Posts: n/a
Default MS SQL dialect question:

query containing entries that begin with same 3 letters as at least one other entry?


How do i create a table from another table containing only those beginning with the same three letters as another entry in the table
so...
abc hello
abc goodbye
ghj must
ghjsomthing

would all be in the new table
Reply With Quote

ANSWER(S):