 |  |  |  |  |  |  |  |
select from part of column query
Please support our MS SQL advertiser: Intel Parallel Studio Home
 |
how do i select data from a table by sorting the first word from a column?
for example:
"user1 hello"
"user2 one two three"
"user3 where are you"
"user1 im fine"
how can i select all the data starting with "user1"?
for example:
"user1 hello"
"user2 one two three"
"user3 where are you"
"user1 im fine"
how can i select all the data starting with "user1"?
MS SQL Syntax (Toggle Plain Text)
Last edited by huangzhi; Aug 25th, 2008 at 5:12 am.
Hence Wijaya
www.ex-Soft.tk
www.ex-Soft.tk
sql Syntax (Toggle Plain Text)
Last edited by peter_budo; Aug 30th, 2008 at 5:43 am. Reason: Keep It Organized - please use [code] tags
|
Similar Threads
- Query logic (MS SQL)
- retrieving a particular value with a sql query (PHP)
- Error accessing database (ColdFusion)
- Get All Rows In Column In A Where Statment (MS SQL)
- How to auto increment? (ASP.NET)
- radio button ASP question?? (ASP)
- select statemt LIKE (MySQL)
- ASP.net/Stored Proc & Login Verification (ASP.NET)
- From chester Heres all the code. Sorry but I just encluded the code in here (Database Design)
Other Threads in the MS SQL Forum
- Previous Thread: MS Access to MS SQL Server
- Next Thread: SQL help
| Thread Tools | Search this Thread |
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MS SQL
"last autogrowth business connectingtodatabaseinuse count cursor data database dateadd datepart day" dbsize deadlock delete_trigger getdate highperformancecomputing hpc hpcserver2008 ibm iis loop maximum microsoft ms mssql multiple multithreading news number permission query reporting result server services sets source sql sqlserver sqlserver2005 supercomputing tables uniqueid update view weekday
