Mega Code Archive

 

Categories / MSSQL / String Functions

 

Begin with a character in the range C through F

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>