SOLVED
How can I add just a letter to a string?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
hellyars
13 - Pulsar
‎01-04-2018
03:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have an account number, but I need to append a single letter 'A' to it. I tried [AccountNumber]+'A'. But, that did not work. I tried changed the Account Number field to be a string and that also did not work. This has to be easy? So, what am I failing to do?
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
2 REPLIES 2
ACE Emeritus
‎01-04-2018
03:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-04-2018
05:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ToString([AcoountNumber]) + 'A' works, but only if I set [AccountNumber] to a V_String and not a Double. That works for me.
