Forumsee logo
Forumsee » Hardware » Networking » Read message
RSS: Subscribe to RSS

Crystal Report Memo Field

Security and Firewalls - Tech Support Forum - www.techsupportforum.com
Hello,

The first line below works in a command in Crystal Reports. What I want to do is take the word "Source" and concatenate it to the slpartsource.sourceindex field. the first line below works. But the "Find1" field is "Memo" field. I want it to be a text field. What I want to do is to be able to see the field in the database so I can join "Find1" field to another field. Any help would be greatly appreciated. Thank you in advance.

select concat('Source',sourceindex) as Find1,* from slpartsource

Left(slpartsource.Find1,40) as Find10


Read responses in techsupportforum.com

Last videos:

Steelseries Rival 600
Steelseries Rival 600
Replacing Nvidia 980M with GTX 1070
Replacing Nvidia 980M with GTX 1070
Instrumental request :)
Instrumental request :)
Intel Optane 900d
Intel Optane 900d
Old Machine Mod
Old Machine Mod
Occasional problem with YouTube on desktop Windows
Occasional problem with YouTube on desktop Windows
Pump Resivour
Pump Resivour
A History of Nvidia GeForce
A History of Nvidia GeForce
Cars · 
Mobility · 
Hardware · 
Motorbikes · 
Travel · 
Boating · 
Aviation · 
production-backend
About Forumsee · Contact · Privacy policy · Request content removal
We use cookies for navigation analysis and personalized advertisement. By using our site, you agree to our use of cookies.
Accept  ·  Learn more