Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
theboman
Starting Member
4 Posts |
 Posted - 2007-03-29 : 16:08:35
|
| Hi, I am using this formula (left([ArticleNo],10)) to select the first ten digits of another field but I want to put some string in front of the result it gets from this, how can I do this?Thanks in advance.Karl. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-03-29 : 16:30:44
|
| you can concatenate the strings..'AA' + (left([ArticleNo],10)) Make sure the ArticleNo is of varchar type else you might to use a CAST or CONVERT function.************************Life is short. Enjoy it.************************ |
 |
|
|
theboman
Starting Member
4 Posts |
Posted - 2007-03-29 : 16:33:46
|
| Excellent, thank you very much,Karl. |
|
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2007-03-31 : 11:26:24
|
| Are these HW questions? |
|
|
|
|
|
|
Formula field question