Forum Discussion
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,
Igor
Column = "a certain string for all rows"
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
3 Replies
Column = "a certain string for all rows"
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