MS Access中的CONCAT等效项 [英] CONCAT equivalent in MS Access

问题描述

我正在MS Access中做一些工作，我需要在一堆字段后面加上一个前缀，我知道SQL，但在Access中似乎不太一样

I'm doing some work in MS Access and I need to append a prefix to a bunch of fields, I know SQL but it doesn't quite seem to work the same in Access

基本上，我需要将其翻译成可以在访问中使用的命令:

Basically I need this translated to a command that will work in access:

UPDATE myTable
SET [My Column] = CONCAT ("Prefix ", [My Column]) 
WHERE [Different Column]='someValue';

我在上下搜索，似乎找不到简单的翻译.

I've searched up and down and can't seem to find a simple translation.

推荐答案

UPDATE myTable
SET [My Column] = "Prefix " & [My Column] 
WHERE [Different Column]='someValue';

据我所知，没有CONCAT

As far as I am aware there is no CONCAT

这篇关于MS Access中的CONCAT等效项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！