How to convert GUID to int !!!

[Anonymous]

Hi guys,

i want to use Peek function to get a value of a specific row but the IDs of field is not a type of integer ,it is a type of uniqueidentifier like

00000000-0000-0000-0000-000000000001

so i want to convert this id to number of type int like :   00000000-0000-0000-0000-000000000001  ==>  1

please can help me to do that .

stalwar1‌

swuehl‌

jvs‌

[swuehl]

As mentioned earlier, you can also use Lookup() function, something like

lookup('Name', 'ID', ' 00000000-0000-0000-0000-00000000004','YourTableName')

However, if you want to resolve your adjacent node hierarchy, you can also look into the Hierarchy LOAD prefixes:

Hierarchies

[Anonymous]

Thanks guys,

It is solved by using mid function as chauhans85 mentioned.