Retrieve data when there's only 1 '.'

Question

Retrieve data when there's only 1 '.'

davdam8

Hall of Fame

Points: 3620
More actions
October 24, 2012 at 3:23 am

#283376

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

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.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
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/