屏蔽表中的值 [英] Masking values in tables

问题描述

我有一个名为Subscriber_ID字段的表格MS Access中的9个alph / numberic字符。我想创建一个更新查询来更新此字段，前五个字符为*****，后四个字符为字母/数字。


因此，如果运行此更新查询它应该更新123456789到***** 6789

有人能告诉我怎么能这样做？我真的很喜欢它。谢谢！

I''ve a table with a field called ''Subscriber_ID" of 9 alph/numberic characters in MS Access. I would like to create an update query to update this field with the first 5 characters with ***** and last four characters as alpha/numeric.

So if run this update query it should update 123456789 to *****6789

Could someone tell me how could I do this? I would really appriciate it. Thanks!

推荐答案

我有一个名为''Subscriber_ID"'的字段的表MS Access中的9个alph / numberic字符。我想创建一个更新查询来更新这个字段，前5个字符用*****和最后4个字符作为字母/数字。

所以如果运行这个更新查询它应该更新123456789至***** 6789

有人能告诉我怎么能这样做？我真的很喜欢它。谢谢！

I''ve a table with a field called ''Subscriber_ID" of 9 alph/numberic characters in MS Access. I would like to create an update query to update this field with the first 5 characters with ***** and last four characters as alpha/numeric.
So if run this update query it should update 123456789 to *****6789
Could someone tell me how could I do this? I would really appriciate it. Thanks!

这是未经测试的，但可能有些帮助......

This is untested, but may be some help...

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

这应该是完美的。

一些（挑剔）建议：

在可能的情况下，在SQL中对字符串分隔符使用撇号（''）是个好主意。 br />
函数的字符串版本（Mid

This should work perfectly.
Some (fussy) recommendations :
It''s a good idea to use apostrophes ('') for string delimiters within SQL where possible.
String versions of functions (Mid

，Format

这篇关于屏蔽表中的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！