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]

 

[TomasDill]

Myvar = ''
Myvar = .NULL. [sig]<p>Vlad Grynchyshyn<br><a href=mailto:vgryn@softserve.lviv.ua>vgryn@softserve.lviv.ua</a><br>[/sig]

 

[foxdev]

Marat, if you are using SQL pass through (using SQLEXEC), use the literal 'NULL'. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

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

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

 

[Marat]

Thanks to all, friends!
I have no problems with SQL path-through but I have a problem with parametrized remote view. Generally it uses a string parameter in uniqueid format ('xxx-xxx ...'), but when it is empty string (or string composed of spaces) SQL Server returns error. I tried 'iif(empty(?par),NULL,?par)' in remote view but it does not work.
Thanks again, Marat [sig][/sig]

 

[foxdev]

If it is the VFP code that you are trying to work out, then modify your clause to read:

[tab]iif(isnull(par), 'NULL', ?par)
or, more appropriately,
[tab]NVL(, 'NULL', ?par)

If you need the clause to actually pass all the way to the server, then use SQL Server's ISNULL, which works a little bit different than VFP's:

[tab] ISNULL(?par, 'NULL')
[sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

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

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

 

[Marat]

Thanks Robert and all!
I'll try it! [sig][/sig]