在FrontBase SQL中将int列转换为varchar？ [英] Convert an int column to a varchar in FrontBase SQL?

问题描述

如何在 FrontBase SQL 中将int列转换为varchar？我需要连接 varchar 和 int 字段，我不能只是连接它们，因为两个参数都需要是varchar。

我想标记这个Frontbase，但我没有权限因信誉<

服务器和数据库版本为4.2.7

查询如下所示：

选择（TVERKOPEN.CPREFIX || CAST（TVERKOPEN.CNUMMER AS VARCHAR））作为PurchaseOrder
从TVERKOPEN

解决方案

尝试：

  CAST（field AS VARCHAR（30））
  

How do I convert an int column to a varchar in FrontBase SQL? I need to concatenate a varchar and an int field, and I cannot just concatenate them because both arguments need to be a varchar.

I wanted to tag this "Frontbase" but I don't have permission due to reputation < 1500.

Server and database version is 4.2.7

The query looks like this:

select (TVERKOPEN.CPREFIX || CAST(TVERKOPEN.CNUMMER AS VARCHAR)) as PurchaseOrder
from TVERKOPEN

解决方案

Try with:

CAST(field AS VARCHAR(30))

这篇关于在FrontBase SQL中将int列转换为varchar？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！