Add new column in table with same value for all rows

[Anonymous]

Hi there,

I know if you want a certain value and it's a digit it's as simple as ColumnName = <value>

But what is the function if you want to have a certain string for all rows?

Kind regards,

Igor

[Greg_Deckler · Accepted solution]

Column = "a certain string for all rows"

[BobBI · Accepted solution]

If column value is number data type then value without quotes (")

ColumnName = value

If column value is text data type then value should be within double quotes( " ")

ColumnName = "value"

Hope this helps.

SS

[Anonymous]

Oh boy, oops.

Thx!

[Greg_Deckler · Accepted solution]

Column = "a certain string for all rows"