MSSQL:

abs(cast(CAST(SUBSTRING(HASHBYTES('SHA1', CAST(CONCAT('SOME','TEXT') as nvarchar(max))),1,8) AS VARBINARY(8)) AS BIGINT))

MYSQL:

CAST(REPLACE(CAST(CONV(SUBSTRING(CAST(SHA(`user`.sysuser_guid) AS CHAR), 1, 16), 16, 10) AS SIGNED INTEGER),'-','') AS CHAR(20))