I need to get the all the row for the value 11 from the below table. Could you give me sql statement for this.
create table teststring(a varchar(25))
insert into teststring
values('11:02,05:BL')
insert into teststring
values('16:03,11:RS')
insert into teststring
values('13:01,04:LL')
insert into teststring
values('16:05,11:RS')
drop table teststring
SQL help
Hot Topic
- Nonclustered, Nonunique Partition Aligned Index fails with Partion Switch
- Cannot create an ODBC connection to SQl 2000.
- MSDE 2000 crashes win2k on after setup
- Audit task
- LastNonEmpty and AverageOfChildren
- SQL Management Studio missing Log Shipping Monitor, and Taskpad View
- publishing downloading report model
- repeating free form list item fields for each group
- SQL Server Mobile Stored Procedure?
- builtin\admin
SQL Server
- Registry to store configuration values ?
- Error locating server/instance specified
- Fit Table on one page if possible
- transaction has already been implicitly or explicitly committed or aborted error
- HostName and ReinitializeSubscription
- SSIS Requests...
- Is it possible to dynamically populate a parameter list with values based on another parameter value?
- SQL Server 2000 application on SQL Server 2005
- Error in sql profiler for analysis srevices 2005
- Problem with ODBC Source
SQL help
zombie_process
Your idea is correct but i feel this could be a positive way instead of <> you could use >
select * from teststring where charindex('11',a)>0
All the Best
MadAboutC#
The below ligic will work better as I expected.
select * from teststring where charindex('11',a)<>0
Bharati Kumars
select * from teststring
where a LIKE '%11%'
Michel Blairon
select * from teststring
where (
substring(a, 1, 2) = '11'
or substring(a, 4, 2) = '11'
or substring(a, 7, 2) = '11'
)
Clifford Dibble
Program Manager, SQL Server