Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add new column in table with same value for all rows

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,...
  • Greg_Deckler's avatar
    7 years ago

    Column = "a certain string for all rows"

  • BobBI's avatar
    7 years ago

    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