Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Selecting date value from string

Author  Topic 

te5elahj
Starting Member

1 Post

Posted - 2014-06-30 : 07:02:32
hi,

I have column (nvarchar(max)) on table: Data is like:
Some text.... Delay Date From: 1.6.2014 Date to: 30.06.2016 some more text

how can I pick Date Value between 'Delay Date From:' and 'Delay Date From:'?

Thanks for any help.

sunder.bugatha
Yak Posting Veteran

66 Posts

Posted - 2014-06-30 : 07:32:04
use CHARINDEX and SUBSTRING to get the required output.

Hema Sunder
Go to Top of Page
   

- Advertisement -