Take a look at SUBSTRING, CHARINDEX and PATINDEX in Books Online.
Thanks
Phillip Carter
Ph: +61 3 9235 1691
-----Original Message-----
From: Dylan Jones
[mailto:mssqldba-ezmlmshield-x55075185.[Email address protected]
Sent: Friday, 25 February 2005 9:54 AM
To: LazyDBA Discussion
Subject: Working With Strings
Hi folks,
I am trying to pull out a string from within a string. For example
within the following string 'Duplicate records - see account #10092.2400
MEMORIAL PKWAY' I want to pull out the ID that follows the # and ends
with the decimal "." . Using VB this is a fairly straightforward
exercise. BOL string functions do not offer what I need to pull this
off. Any ideas?
Dylan A Jones
SQL DBA
SurfControl Inc (Scotts Valley)
w: 831 440 2568
m:831 566 3089
Get the latest news on SurfControl and our products, subscribe to our
monthly e-newsletter, SurfAdvisory at:
http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.as
px
*********************************************************************
The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken or
omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error,
please contact the sender.
*********************************************************************
SurfControl Inc.
5550 Scotts Valley Drive
Scotts Valley, California 95066
831-440-2500
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
IMPORTANT DISCLAIMER - THIS MAY AFFECT YOUR LEGAL RIGHTS:
Because this document has been prepared without consideration of any
specific clients investment objectives, financial situation or needs,
a Bell Potter Securities Limited investment adviser should be
consulted before any investment decision is made.
While this document is based on the information from sources which
are considered reliable, Bell Potter Securities Limited, its directors,
employees and consultants do not represent, warrant or guarantee,
expressly or impliedly, that the information contained in this document
is complete or accurate.
Nor does Bell Potter Securities Limited accept any responsibility to
inform you of any matter that subsequently comes to its notice, which
may affect any of the information contained in this document.
This document is a private communication to clients and is not intended
for public circulation or for the use of any third party, without the
prior approval of Bell Potter Securities.
Disclosure of Interest: Bell Potter Securities Limited receives commission
from dealing in securities and its authorised representatives, or introducers
of business, may directly share in this commission. Bell Potter Securities
and its associates may hold shares in the companies recommended.
Bell Potter Securities Limited ABN 25 006 390 772 AFS Licence No. 243480
MS Sql Server LazyDBA home page