One bit replacing

mariaasl · #1 (**permalink**) 10-05-03, 07:29

Hi all,

I am working in VB6. How can I replace a first byte in GUID value with a constant?

Thanks a lot for your help!

ms_sql_dba · #2 (**permalink**) 10-16-03, 13:09

Code:

create table t1 (f1 uniqueidentifier, f2 char(1))
go
insert t1 values (newid(), 'A')
go
select * from t1 where f2 = 'A'
go
declare @s varchar(36)
select @s = f1 from t1 where f2 = 'A'
set @s = '1' + substring(@s, 2, 35)
update t1 set f1 = @s where f2 = 'A'
go
select * from t1 where f2 = 'A'
go
drop table t1

mariaasl · #3 (**permalink**) 10-20-03, 08:59

Thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech