Re: [SQL] Join columns

2004-06-25 Thread Achilleus Mantzios
O kyrios Przemys³aw S³upkowski egrapse stis Jun 25, 2004 : > Hi > How can I generate md5 chcecksum for a row in table. I have 47 columns in table and > I want to generate chceck sum to check is integrity od data. > I want to do something like this > > select md5((idTowBK || SKDK || SKDT || SKGR

[SQL] Join columns

2004-06-25 Thread Przemysław Słupkowski
Hi How can I generate md5 chcecksum for a row in table. I have 47 columns in table and I want to generate chceck sum to check is integrity od data. I want to do something like this   select md5((idTowBK || SKDK || SKDT || SKGR || SKIR || SKKL || SKKR || SKLM || SKNZ || SKOP || SKPR)::varchar