Convert string to uniqueidentifier

[Marat]

Hello!
I need to get a result set from the table on SQL Server 7.0 by passing parameter that refers to table's foreign key. Type of foreign key is uniqueidentifier, type of parameter is string. But when parameter is empty string ('') I recive an error 'can't convert string to uniqueidentifier'.

What can I do to SQL Server interprets empty string as NULL?

Thanks
tolgambaev@hotmail.com [sig][/sig]

 

[foxdev]

Marat, I've answered this in the VFP forum.
You'll want to pass 'NULL' for null values. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]