<div>
Good luck with that. &nbsp; Your requirements are to consume a date value stored in a varchar(255), validate that it's a good date, then calculate age to include year/month/day differences, all of which require some kind of script such as a stored procedure or function. &nbsp; You can store an expression in a view but that's asking a lot. <br />
<br />
Who's requirement is it to not allow a SP or function? <br />
<br />
So for the moment I'll go with 'you can't do that' as the correct answer. <br />
<br />
&gt;The database is SQL 2005.<br />
Just to 'check the box', this version is five version sold (2008, R2, 2014, 2014, 2016) and is <a href="https://www.microsoft.com/en-us/cloud-platform/sql-server-2005" rel="ugc">no longer supported by Microsoft</a>, so your client needs to 'live in the now' and upgrade.
</div>


<div>
Thanks Jim<br />
<br />
I do know its a good date. &nbsp;Just year from this point is good. &nbsp;Sorry that I implied month and day. &nbsp; I do not have create rights for SP or Functions. &nbsp;It is FDA validated database and if that changes it needs to be re validated. That's not going to happen. Cant create a view either.
</div>


<div>
Jim By the way this is part of an upgrade in an attempt to live in the now. &nbsp;Client is massive with almost a billion records in the database
</div>


<div>
I have requested deleting this because I did not explain why and what to the best. I reentered it hopefully more descriptive of issue
</div>


<div>
I object to the deletion as my answer was correct as the question was asked, and should not be penalized for the question not being accurate in the first place. <br />
<br />
Check out ​<a href="https://www.experts-exchange.com/articles/18499/Top-10-Ways-to-Ask-Better-Questions.html" rel="ugc">Top 10 Ways to Ask Better Questions</a> for more helpful tips on how to engineer questions to get faster answers.
</div>


<div>
I actually disagree with you that the answer &quot;you can't do that&quot; &nbsp;is correct even in the moment. &nbsp;I would have never awarded any points or accepted that as an answer. Your sarcasm as well was not appreciated either. I am not going to tell my good, billion dollar company client to &quot;Live in the now&quot; or sarcastically wish them luck and inform them that 2005 is obsolete, &nbsp;they know that. That is why we are doing this.<br />
<br />
If the points are the only thing driving you and you want them and the admins are okay with an answer in the moment. Then you can have them.
</div>


<div>
You can do it easily by using the CONVERT function. Example:<br />

<pre><code class="code-1 nolinks" id="code-20-42072901-1"><span>DECLARE @MyDate AS VARCHAR(255) = '1971-02-12'</span>
<span></span>
<span>SELECT DATEDIFF(year,CONVERT(smalldatetime,@MyDate,104),GETDATE())</span>
<span></span>
<span>-----------</span>
<span>46</span>
<span></span>
<span>(1 row(s) affected)</span>
</code></pre>
You just need to replace <b>@MyDate</b> variable with your current column name.
</div>


<div>
Thank You,<br />
<br />
This can work. &nbsp;I went back and forth on whether needed exact age. &nbsp;Discussed with manager and we do. It is holding Medical records that by law need a cutoff if we are not going to migrate records. All records on Minors at time of document must be migrated &nbsp;to a new system. So if a Minor was 17 year and 8 months we must do it. &nbsp;It is a hospital records system. Old one is very very very large that has collected records for 25 years and all kinds of HIPPA laws on what I do with data apply.
</div>


<div>
<div class="content wysiwyg-content">
I need to calculate exact age from today. &nbsp;It must be in T-SQL I can not create a store procedure or function. &nbsp;Another twist is the date as stored in a Varchar(255) type. &nbsp; It has a format like &nbsp;YYYY-mm-dd &nbsp;ex 1971-02-12. &nbsp;The database is SQL 2005.<br />
<br />
Thank You
</div>
</div>


I need to calculate exact age from today.  It must be in T-SQL I can not create a store procedure or function.  Another twist is the date as stored in a Varchar(255) type.   It has a format like  YYYY-mm-dd  ex 1971-02-12.  The database is SQL 2005.

Thank You

SQL Need to calculate age from DOB, no stored procedures or functions allowed

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The Health Insurance Portability and Accountability Act of 1996 (HIPAA; Pub.L. 104–191, 110 Stat. 1936, enacted August 21, 1996) was enacted by the United States Congress and signed by President Bill Clinton in 1996. It has been known as the Kennedy–Kassebaum Act or Kassebaum–Kennedy Act after two of its leading sponsors. Title I of HIPAA protects health insurance coverage for workers and their families when they change or lose their jobs. Title II of HIPAA, known as the Administrative Simplification (AS) provisions, requires the establishment of national standards for electronic health care transactions and national identifiers for providers, health insurance plans, and employers.