title: Checking a DateTime which is part of a larger nvarchar
body: <p>I have a table, let's call it 'tblData'. which has a field called 'details' which is a nvarchar(4000). in this field there might be a text like such : 
  'blah blah ## 12/08/1982 ## blah blah'. the part that starts and ends in '##' might or might not exist.</p>
  
  <p>I need to make a select statement with a where clause which will not return a row that has '## [date] ##' that is in the future. if the '## [date] ##' part does not exist, return the row.</p>
  
  <p>is this possible to do without using a function?
  and if I have to use a function, some sample code could come in handy as I barely know any tsql... 
  10x alot!</p>