Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create view vMaskPeople
- as
- SELECT ID, DateCreated, 'Sample Name' as FullName, 'Sample Telephone' as Phone
- FROM People
- SELECT ID, DateCreated,
- Left(FullName,3)+'XXXXXX' as FullName,
- 'XXX-XXXX-'+Right(Phone,4) as Phone
Add Comment
Please, Sign In to add comment