Share
ReportI'm looking for a sql query to move the data from the extended description to the notes field
*This post is locked for comments
You’re offline. This is a read only version of the page.
215
I'm looking for a sql query to move the data from the extended description to the notes field
*This post is locked for comments
Hi Tom.
Try this next, in two different steps / two different queries :
1º) first SQL query would be "UPDATE Item SET Notes = ExtendedDescription"
2º) second SQL query would be "UPDATE Item SET ExtendedDescription = '' " , where You use simple quotes (')
If You do it in a same query, You may loose the information you have in ExtendedDescription field. Also, make a database BACKUP before You do the queries...
Regards, A.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (