Begin with a character in the range C through F : Regular Expressions « String Functions « SQL Server / T-SQL

1. SQL Server / T-SQL
2. String Functions
3. Regular Expressions

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>
           
       

Related examples in the same category