/[cvs.andrew.net.au]/uni/COMP2400/q2.sql
ViewVC logotype

Diff of /uni/COMP2400/q2.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.3 by apollock, Tue Aug 10 01:28:52 2004 UTC revision 1.4 by apollock, Tue Aug 10 11:43:50 2004 UTC
# Line 10  COLUMN PersonID FORMAT A10 HEADING 'Pers Line 10  COLUMN PersonID FORMAT A10 HEADING 'Pers
10    
11  SELECT PersonId  SELECT PersonId
12  FROM Person  FROM Person
13  WHERE Firstname like '&1%' AND Surname = '&2';  WHERE UPPER(Firstname) like UPPER('&1%') AND UPPER(Surname) = UPPER('&2');
14    
15  EXIT  EXIT

Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4

  ViewVC Help
Powered by ViewVC 1.1.22