请教大侠个问题，急用
我有一个字段保存的是 001-023,014-089 之类的文本值（可以为空），现在要用中间的 025 查找去得到符合条件的行，SQL要怎么写？

[解决办法]

SQL code

select * from tb where charindex('-025-','-'+COL+'-')>0
[解决办法]
那需要先拆列.
探讨

024-089 是表示024 到089 包含中间的值

[解决办法]
SQL code
declare @num varchar(10)set @num='025'select  id from tb where @num between parsename(replace(num,'-','.'),2) and parsename(replace(num,'-','.'),1)
[解决办法]
SQL code
--> 测试数据：[tb]IF OBJECT_ID('[tb]') IS NOT NULL DROP TABLE [tb]GO CREATE TABLE [tb]([ID] INT,[NUM] VARCHAR(7))INSERT [tb]SELECT 1,'001-023' UNION ALLSELECT 2,'024-089' UNION ALLSELECT 3,'090-100'--------------开始查询--------------------------DECLARE @i VARCHAR(10)SET @i='025'SELECT * FROM [tb] WHERE @i BETWEEN LEFT([NUM],CHARINDEX('-',[NUM])-1) AND RIGHT([NUM],CHARINDEX('-',[NUM])-1)----------------结果----------------------------/* ID          NUM----------- -------2           024-089(1 行受影响)*/
[解决办法]
SQL code
------------------------------ Author  :fredrickhu(小F，向高手学习)-- Date    :2012-07-10 14:48:37-- Version:--      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (Intel X86) --    Apr 22 2011 11:57:00 --    Copyright (c) Microsoft Corporation--    Enterprise Edition on Windows NT 6.1 <X64> (Build 7600: ) (WOW64)--------------------------------> 测试数据：[tb]if object_id('[tb]') is not null drop table [tb]go create table [tb]([ID] int,[NUM] varchar(7))insert [tb]select 1,'001-023' union allselect 2,'024-089' union allselect 3,'090-100'--------------开始查询--------------------------declare @num varchar(10)set @num='025'select  id from tb where @num between parsename(replace(num,'-','.'),2) and parsename(replace(num,'-','.'),1)----------------结果----------------------------/* id-----------2(1 行受影响)*/
[解决办法]
SQL code
--> 测试数据：[tb]IF OBJECT_ID('[tb]') IS NOT NULL DROP TABLE [tb]GO CREATE TABLE [tb]([ID] INT,[NUM] VARCHAR(7))INSERT [tb]SELECT 1,'001-023' UNION ALLSELECT 2,'024-089' UNION ALLSELECT 3,'090-100'--------------开始查询--------------------------DECLARE @i VARCHAR(10)SET @i='025'SELECT * FROM (SELECT * FROM [tb] WHERE CHARINDEX('-',[NUM])>0--先查询出来包含有-的，如果数据都包含有这个，则不需要这一步)t WHERE @i BETWEEN LEFT([NUM],CHARINDEX('-',[NUM])-1) AND RIGHT([NUM],CHARINDEX('-',[NUM])-1) ----------------结果----------------------------/* ID          NUM----------- -------2           024-089(1 行受影响)*/
[解决办法]
SQL code
declare @t table (id    int not null,Num varchar(8)    not null)insert into @tselect 1, '001-023' union allselect 2, '024-089' union allselect 3, '090-100' declare @n varchar(4)set @n = '025'select * from @twhere @n>=left(num,charindex('-',num)-1) and @n<=right(num,len(num)-charindex('-',num))