"Agnes" <agnes@dynamictech.com.hk> wrote in message
news:u%23reqzlcEHA.1000@TK2MSFTNGP12.phx.gbl...
> select (sealno + trim(unit) ) as key from myTable
> I need to have my key , however, i need remove the space in "unit" field
and
> i can't use trim..
> What should I do , thanks
> From agnes
>
>

> 1) KEY is a reserved word and too vague to be a column name anyway. I
> hoped that was just for the psuedo-code.
>
> 2) You need to add a constraint to the unit column so that you do not
> get unwanted spaces in it in the first place. Basic data quality rule:
> when you find a leak (DML), don't forget to fix the pipe (DDL) after you
> mop the floor.
>
> 3) There is nothing wrong with a two-column key, so what is the reason
> for the concatenation? If you are doing this for display, then that
> would be a violation of the tiered architecture. That kind of thing was
> done in COBOL a lot because the langauge assumed contigous storage and
> it was easy to declare a single field in the file to build a
> concatenated field for display.
>
> --CELKO--
> ===========================
> Please post DDL, so that people do not have to guess what the keys,
> constraints, Declarative Referential Integrity, datatypes, etc. in your
> schema are.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!