Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combining fields with SQL?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00411282
Message ID:
00411382
Views:
10
Hi David,
>
>When did that change? I've padded combined expressions like that for years to avoid a problem that seems not to exist anymore. Just tested it without the PADR and surprise -- no problem.
>
>>>select table1.employee_id, ;
>>>ALLTRIM(employee.first_name) + " " + ALLTRIM(employee.last_name) AS FULL_NAME ;
>>>FROM table1, employee
>>>WHERE table1.employee_id = employee.employee_id ;
>>>INTO table3
>>
>>Better PADR that expression, or you'll lose info if the first item has short first and/or last name.

Are you SURE <G> that the Full_Name that VFP evaluated first was short? I'll bet you were just 'lucky' PadR() takes 'luck' into your hands! <G>
Bill Armbrecht
VFP MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform