Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Retrieve data when there's only 1 '.' Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2012 3:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668


Hi geniuses.
I got a report to build and I need data from a field which contains lots of junk data, like:

MNN.helloworld
SSD.goodbyeworld
DDS.seeulaterworld.oops
....

What I really need when there's only 1 '.' in the data.

How do I Where this up?

Thanks
Regards
Post #1376376
Posted Wednesday, October 24, 2012 3:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:14 AM
Points: 2,379, Visits: 7,585
davdam8 (10/24/2012)


Hi geniuses.
I got a report to build and I need data from a field which contains lots of junk data, like:

MNN.helloworld
SSD.goodbyeworld
DDS.seeulaterworld.oops
....

What I really need when there's only 1 '.' in the data.

How do I Where this up?

Thanks
Regards


Duplicate post. Replies here (http://www.sqlservercentral.com/Forums/Topic1376365-391-1.aspx) please.



Not a DBA, just trying to learn

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better, quicker answers on SQL Server performance related questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/



If you litter your database queries with nolock query hints, are you aware of the side effects?
Try reading a few of these links...

(*) Missing rows with nolock
(*) Allocation order scans with nolock
(*) Consistency issues with nolock
(*) Transient Corruption Errors in SQL Server error log caused by nolock
(*) Dirty reads, read errors, reading rows twice and missing rows with nolock


LinkedIn | Blog coming soon (for sufficiently large values of "soon" )!
Post #1376381
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse