General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Everyone:
I am trying to convert a memo field into a character filed. My code Substrc(Mline(Sysaddr.Fmstreet,1),1,120) returns the character value of the memo field for first line of address, however if the memo field contains a second line of address it is ignoreing that second line. What I need is bothe lines of address. I.E. (123 main street suite 10A.) I am only getting 123 mian street and not both address. Is there a way where I can have both line of address.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only