got it
From: marcmc (marcmc_at_discussions.microsoft.com)
Date: 03/23/05
- Previous message: marcmc: "substring update?"
- In reply to: marcmc: "substring update?"
- Next in thread: Uri Dimant: "Re: substring update?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 23 Mar 2005 08:19:01 -0800
Update POt_lu_rd_post_code
set Po_rd_postcode_id = 'GED ' + substring(Po_rd_postcode_id,5,4)
WHERE Po_rd_postcode_id like 'UK %'
- Previous message: marcmc: "substring update?"
- In reply to: marcmc: "substring update?"
- Next in thread: Uri Dimant: "Re: substring update?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
