1> CREATE TABLE department(dept_no CHAR(4) NOT NULL,
2> dept_name CHAR(25) NOT NULL,
3> location CHAR(30) NULL)
4> GO
1> insert into department values ('d1', 'developer', 'Dallas')
2> insert into department values ('d2', 'tester', 'Seattle')
3> insert into department values ('d3', 'marketing', 'Dallas')
4> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
1> -- Begin with a character in the range C through F.
2>
3> SELECT * FROM department WHERE location LIKE '[C-F]%'
4> GO
dept_no dept_name location
------- ------------------------- ------------------------------
d1 developer Dallas
d3 marketing Dallas
(2 rows affected)
1> drop table department
2> GO
1>
|