<div>
You can create a SQL Function that would return whether a GUID is valid:<br />
<br />
<a href="http://ask.sqlservercentral.com/questions/23114/best-way-to-check-that-a-stringvarchar-guid-is-val.html" rel="ugc">http://ask.sqlservercentral.com/questions/23114/best-way-to-check-that-a-stringvarchar-guid-is-val.html</a>
</div>


You can create a SQL Function that would return whether a GUID is valid:

http://ask.sqlservercentral.com/questions/23114/best-way-to-check-that-a-stringvarchar-guid-is-val.html [http://ask.sqlservercentral.com/questions/23114/best-way-to-check-that-a-stringvarchar-guid-is-val.html]

want to do it in C#, ASP.net. But let me look at your link

<div>
Why not use <a href="http://msdn.microsoft.com/en-us/library/system.guid.tryparse.aspx" rel="ugc">Guid.Tryparse</a>?
</div>


Why not use Guid.Tryparse [http://msdn.microsoft.com/en-us/library/system.guid.tryparse.aspx]?

<div>
so if (Guid.Tryparse(field) = true)<br />
<br />
?
</div>


<div>
<div class="content wysiwyg-content">
I have a sql statement that joins to 2 tables and brings back an ID row. I changed the design and the new IDs are integers. The old IDs are GUIDs.<br />
<br />
How can I know if the ID is GUID and not an integer? based on that, i want to use an if-else statement.<br />
<br />
thanks
</div>
</div>


I have a sql statement that joins to 2 tables and brings back an ID row. I changed the design and the new IDs are integers. The old IDs are GUIDs.

How can I know if the ID is GUID and not an integer? based on that, i want to use an if-else statement.

thanks

How to know if a string is GUID?

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications