MS SQL RSS MS SQL RSS

select from part of column query

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Aug 2008
Posts: 2
Reputation: peanutong is an unknown quantity at this point 
Solved Threads: 0
peanutong peanutong is offline Offline
Newbie Poster

select from part of column query

 
0
  #1
Aug 25th, 2008
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"?
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2008
Posts: 42
Reputation: huangzhi is an unknown quantity at this point 
Solved Threads: 13
huangzhi huangzhi is offline Offline
Light Poster

Re: select from part of column query

 
0
  #2
Aug 25th, 2008
MS SQL Syntax (Toggle Plain Text) 
  1. SELECT * FROM tb_TableName WHERE AColumn LIKE 'user1%'
Last edited by huangzhi; Aug 25th, 2008 at 5:12 am.
Hence Wijaya
www.ex-Soft.tk
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 20
Reputation: prasannapower is an unknown quantity at this point 
Solved Threads: 0
prasannapower prasannapower is offline Offline
Newbie Poster

Re: select from part of column query

 
0
  #3
Aug 30th, 2008
sql Syntax (Toggle Plain Text) 
  1. SELECT*FROM (Tablename) WHERE (Colom) ," "
Last edited by peter_budo; Aug 30th, 2008 at 5:43 am. Reason: Keep It Organized - please use [code] tags
Prasanna
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the MS SQL Forum
Thread Tools Search this Thread



connectingtodatabaseinuse count cursor database datepart deadlock delete_trigger highperformancecomputing hpc hpcserver2008 ibm iis loop maximum microsoft ms multithreading news number permission query result server sets sql sqlserver sqlserver2005 supercomputing uniqueid update view
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC