Èñïîëüçîâàíèå ôóíêöèè Trim
|
|
Ñóááîòà, 12 Äåêàáðÿ 2015 ã. 19:49
+ â öèòàòíèê
Âñåì ïðèâåò. Ïîìîãèòå ñàëàãå. Íå ïîéìó ÷åãî îò ìåíÿ Access õî÷åò. Êàê åìó åùå Òrim çàïèñàòü? Ïèøåò îøèáêà êîìïèëÿöèè.
SELECT authors.au_fname, TRIM([authors.au_lname]) AS Âûðàæåíèå1, authors.city, authors.state
FROM authors
ORDER BY authors.state, authors.city DESC;
http://www.sql.ru/forum/1190219/ispolzovanie-funkcii-trim
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-