SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 retreiving a part from data field		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

resmid
Starting Member

India
1 Posts
Posted - 11/18/2012 :  09:53:54  Show Profile  Reply with Quote
please help me to extract the sentence after RESPMSG in sqlquery
<span class="bold-text">RESPMSG:</span> Invalid account number<br />

khtan
In (Som, Ni, Yak)

Singapore
16769 Posts
Posted - 11/18/2012 :  10:11:31  Show Profile  Reply with Quote 
replace(column_name, 'RESPMSG:', '')


KH
Time is always against us
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
48012 Posts
Posted - 11/19/2012 :  01:51:56  Show Profile  Reply with Quote
so what should be output? everything after RESPMSG or only text invalid account number?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000